Lookup Wizard

[Dave Titan]

Hi Folks,

On a table I've used the lookup wizard to create a drop down list of 10 "subjects".

My question is, if I want to add say another 5 "subjects". How can I do this without having to re-type the whole 10 Subjects and then add the new 5?

This can really get painful is you have a list of say 20 and just want to add one more to the list, you have to do up a list of 21!

Any help would be much appreciated

Dave

 

[Rich]

This is a classic example of why you shouldn't use lookups directly in a table, create a new table and form so that you can enter as many definitions as you want. You should only store the PK from the lookup table as the FK in your original table, having set up a one to many relationship between the two.

 

[Dave Titan]

Apologies but that made no sense to me?!! The lookup column is being accessed through a form, but I want to make the changes in the original table

 

[SAK]

Sounds like look up wizard is fired up with when adding a combo box. If I am correct you get two options then, 1-enter the values you want or 2-choose from a query or table.

The second option involves data you establish before hand, generally in a table.

So this is the way to go.

A bonus is, that sometimes you don't even have to make the table, but query what you want from an existing table. For example if you wanted to look up first names, a SELECT DISTINCT query would give you all your first names with no duplicates.