using LOOKUP

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

Guest

Hey

I'm trying to create a database where FIELD1 is a lookup box and each of the
options in FIELD1 will bring up a different list in FIELD2 in the same row.
Is that clear enough?? Hope you can help

David
 
On Wed, 8 Jun 2005 20:59:02 -0700, David Gaines <David
Hey

I'm trying to create a database where FIELD1 is a lookup box and each of the
options in FIELD1 will bring up a different list in FIELD2 in the same row.
Is that clear enough?? Hope you can help

David
Click to expand...

Use a Form to view and edit your data, rather than a Table. Table
datasheets ("databases" in your terminology, though a "database" in
Access is the .mdb file containing all the tables, forms, reports
etc.).

It's easy to put two Combo Boxes ("lookup boxes") on a Form, and have
one of them depend upon the other. It's all but impossible in a table
datasheet.

John W. Vinson[MVP]
 
Back
Top