Lookup Question

[uaguy3005]

My question may be more a choice of preference, but is it better to use a look up table or just use the value list for combo box selections in a main table? For example, if I had a main table (tblIssuesList) and one field was Model, should I use the combo box and value list or create a look up table (tblModel) to link to the Model field in tblIssuesList.


Thanks in advance!

[ssanfu]

My rule of thumb is if the data will change very rarely, use a value list. Otherwise, use a look-up table.
For example,
days of the week - you more than likely won't add an eighth day - use a value list.
Male/Female - value list.

Model of Nike shoes - definitely a look-up table.
Automobile models - look-up table.

So I use look-up tables the majority of the time.

My $0.02 worth.....