from to add new lookup value

[tweety]

I have a i one my tables a field when i have typed in lookup values (in the products table there is a field called product type which has the values Bubble Gum, Candy, Jelly, Lolly Pop and Marshmallow)

how do i made a form so the end user doesnt need to go into the table design to edit this list, or add new product type



thanks in advance

[June7]

One way is to have a table ProductTypes. Then the lookup can query the ProductTypes table.

BTW, recommend not having lookups in tables. Do this in comboboxes on form.

[Missinglinq]

...(I) recommend not having lookups in tables. Do this in comboboxes on form...

I second that recommendation! For the why, click here:

The Evils of Lookup Fields in Tables

Linq ;0)>