How Do You Decide On A List Type For A Microsoft Access Table Field?
You can use two list types in a MS Access table field. A Value list contains values that you create. A Lookup list contains values that you take from another table or query. Your choice depends upon the values that you want to add. These instructions apply to MS Access 97. Select a Values list when you want to enter your own predefined values. This works best when the values do not change very often and there is no need for you to store them in a table. For example, you could use a Values list in a Salutation column and enter predefined values such as “Mr.”, “Miss”, “Mrs.”, “Ms”, and “Dr.” Select a Lookup list if another table or query contains the values you want to add. For example, you might have an address table containing contact information for all of your employees. A second table might contain information about employees who have earned sales commissions this month. By inserting a Lookup list in the Sales Commission table made up of employee names from the Address table, you co
