Expert: Scottgem - 11/4/2005

Question
Hi,

I think in our last correspondence you suggested that I never have a table where one of the properties of a field is a lookup field. You said that (for example) if there is a field named HomeRoom and the correct choices are 7Gr-01, 7Gr-02 and 7Gr-03 that I should have that be part of the form because the user should not directly interact with a table. How do I do that via the form?

"He is a PhD Student, a pupil having difficulty" :-)

Thanks,
(Drowning in Details about Students)
Tom  

Answer
That is correct. Lookup FIELDS on table level are not recommended. They cause more problems than they are worth. You can do a lookup on a form in a variety of ways. The most common is using a combobx control. Just use the Combobox wizard (very similar to the lookup field wizard) to create the control.

You can also use Listboxes or option groups. Listboxes are valuable when you need to select multiple values or display multiple columns. Option groups work when you have a short, static list of choices.

HTH
Scott<>