In a Custom İtem table,each table item has one of four possible models and no other models will ever be added.The user must be able to select one of these four models by pressing F6 key and selecting from list.What is the best data type to use for the model field?
How big is the chance that this list ever changes (model removed/replaced/added) ?
If that cance is ver,very low, you can go with Option, otherwise you should implement a “Model” table with Code and Description fields, then add a code field to the item table and set the table relation to the “Model” table.
Thx Data Type is Option 