Lookup Table Question

[Beanie_d83]

Hi all,



When you create a lookup to a table using the lookup wizard, where does it get saved and how might you modify the lookup once created? I have tried using the Modify Lookups button on the design tab but all it seems to do is add a field into the table that I don't want.

[ranman256]

when you say lookup, do you mean
a combo box on a form?
or
a table joined to another in a query?
or
a table to feed a field in another table?

[Beanie_d83]

A table to feed a field in another table

Though I think I've been here before and the combo box is the better way!