Look up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am using Access 2000. I have set up a number of related tables. The
main table contains look-up fields to the other tables. When I view the
datasheet, I can see the drop down arrows on the right of the look up fields.
I created a query and the result still shows the drop down lists.
However, when I create a form (using the form wizard) the fields are plain
text and not drop down. My understanding was that if I set it up correctly
in the table, the look ups would transfer to the query and form. It does
not seem to be happening with the form, though. Thanks in advance. Jazz
 
Jazz,

Your assumption is not correct, look-ups in a table's design don't
automatically make "drop-downs" in forms. If you are going to work
through forms (which is the right thing to do), you should use combo
boxes ("drop-downs") on the form, instead of plain text boxes. You don't
need the look-ups in the table at all, and you'd better remove them from
the table design, in the interest of performance and integrity.

HTH,
Nikos
 
Back
Top