[AccessD] A Design Opinion, Please

I've just been bitten by Lookup fields in a table.

I've got an old application, originally written in Access 97 and subsequently 
upgraded to Ak2. 

Using A2K3, I was trying to clean out all of the data to set up a new clean 
version. Every time I tried to open one particular table to delete the 
records, Access froze solid. 

I finally opened the table in Design view and found that a couple of fields 
had lookups defined.  Once I removed the lookups and saved the table, I 
could open it and delete the data.  

Cheers,
Stuart

On 22 Feb 2009 at 12:19, Tina Norris Fields wrote:

> William, you said you learned the hard way never to set a lookup field 
> in a table.  Please tell me why - that sounds like just exactly the 
> lesson I need.