how can i limit to a list on a table

[Guest]

how do i set the properties for a lookup column on a table so that the values
i enter for that field have to be listed on the list box?
--

 

[Rick B]

In general, you should not define a lookup in your table. Do it in your
forms. There is a setting in the properties for "limit to list".

 

[John Vinson]

how do i set the properties for a lookup column on a table so that the values
i enter for that field have to be listed on the list box?

You can't.

The Lookup feature in table datasheets is of VERY limited utility.
This is one of the limitations.

Instead, use a Form; set the RowSource property of the listbox to a
query selecting the values from the table. If values repeat in the
table, set that query's Unique Values property to Yes.

John W. Vinson[MVP]