Remove Lookup fields in tables

[Mark]

I have inherited a database in which the previous designer appeared to be a
fan of Lookup fields within tables. I am about to go through and remove
these. What do you recommend I check before I do so? What/If any are
likely problems with doing this?

thanks in advance

Mark

 

[John Vinson]

I have inherited a database in which the previous designer appeared to be a
fan of Lookup fields within tables. I am about to go through and remove
these. What do you recommend I check before I do so? What/If any are
likely problems with doing this?

thanks in advance

Mark

Open each table in design view; for each Lookup field, select the Lookup tab
on its Properties window and change it from "Combo Box" to "Textbox". This
will display the actual table contents rather than the lookup.

The only other "gotcha" is that the Lookup Wizard creates additional
relationships even if relationships exist. Open the Relationships window and
Show All; select any redundant join lines and delete them, then delete any
duplicate table icons (they'll end in _1 or _2). Also doublecheck each
table's Indexes - there may be duplicate indexes as well.