Table Design

F

flavi

What I am trying to do is create a table where when you select a distributor
in one lookup column, the next column has only the OEM's of that specific
distributor. I have been reading Lookup columns for 2 days now and not sure
how to go about this. I know how to create dependent combo boxes, but not
sure how to incorporate this into a table. Any suggestions?

Summary: Dependent column based on another column.


Thanks in advance,

Bradley
 
J

Jeff Boyce

Bradley

You don't.

Access tables store data, Access forms display it.

If you want to use "cascading comboboxes", do so in a form.

By the way, there is considerable opinion against the use of the "lookup
datatype" in Access tables. You have (re-)discovered one of the reasons ...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Adding a big matrix in Word 2013 5
Cannot sort a table containing text 5
Multivalued fields in Access 2003 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Page numbering with Merged Document and IF statements 1
Building cascading lookups in an Access 2007 table 1
Table Preferred width is changed when pasting 1

Top