If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Table Design
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 |
#2
|
|||
|
|||
Table Design
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 "flavi" u47075@uwe wrote in message news:8c014be210012@uwe... 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 |
Thread Tools | |
Display Modes | |
|
|