Hi Marcia,

I'm not sure what you mean here by "there is no dropdownlist that informs the user of what values are appropriate".

If a lookup has been established for a specific field in a table like a list or a dataset, then if you are inserting a new row to that table, the UI will show that field as a dropdown box rather than a free text field to type in.

Can you provide us with screenshots of the following:

1. The list that you mentioned.

2. The part where you say you're visually not seeing this dropdown list.

3. How you've setup the foreign key lookup that you said you established.

Regards,

Jon