Depending on the number and depth of them, you can either use separate tables for each, or combine all of them into one table. However, a single table lookup will require some additional design considerations. For example, if some of your lookup values are numeric while others are text, then you will probably have to convert the numeric values into text, to be able to keep all the lookup values in one column in the same table. You would then, probably, have to convert them back into numbers in your forms where you would use the lookups.In addition I have several similar List that I use the same way.
Just to be clearer, you don't want to design the lookup at the table level. Instead, you would use a combo or listbox on the form.So to be clear, I would design it in the table as a lookup the use it on my form as a combo or listbox?
Let me be more specific, I have a table with just the list, then let's say in another table called Customers, I would include a field that has list table and define the field in the Customers table as a Lookup? or Short Text?Just to be clearer, you don't want to design the lookup at the table level. Instead, you would use a combo or listbox on the form.
Okay, let's say you have a table with a list of values you want to look up. This table should have a primary key field. For example:Let me be more specific, I have a table with just the list, then let's say in another table called Customers, I would include a field that has list table and define the field in the Customers table as a Lookup? or Short Text?
Or, just use Combobox or listbox in form?
ID Payment
1 Cash
2 Credit Card
3 Check
ID Payment Date
1 1 1/14/2022
2 3 1/12/2022
Someone needs to send that memo around MS because they don't seem to get it.and just to add - just because you can doesn't mean you should
Not putting words into anyone's mouth or trying to infer motives, but my impression is that leaving lookup fields in tables probably reflects how hard it is to walk back mistakes loudly and publicly asserted. Pulling them out would be tantamount to admitting a mistake; it won't happen.Someone needs to send that memo around MS because they don't seem to get it.