Combobox help!

[AccessForumUser]

i'm wondering if this scenario is possible.. it sounds promising but i haven't been able to figure it out.. i'm newer to access.

I am trying to link 3 tables. First one will display a cell phone manufacturer. Second show the model of phones from that manufacturer depending on which one was picked in 1st table. Third combobox should display the manufacturer part number.. So it's basically drilling down to capture all the info of phone.. see example below:

1st table:
Apple
Samsung
ZTE



2nd table: -depending on answer from 1st, should show model number of phone
iPhone model number or,
Galaxy model number or,
zte model..

3rd table: - depending on answer from 2nd, options should show manufacture number of model..
A1518 or manuf. model of phone

When i make a form with combo boxes, the relationships don't seem to distinguish between what type of model numbers to display in the second box.. i tried linking with id's but that was a disaster!

If there's anyone out there that can direct me on the easiest way to do this, that would be much appreciated! Thanks.

[pbaldy]

Sounds like:

Baldy-Cascading Combos

[ssanfu]

What are the fields in the 3 tables?
Are the tables linked with PK/FK fields?

[orange]

As Paul said review Cascading Combo

Here are 2 older videos on the topic
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html

Good luck

[AccessForumUser]

Thanks for the video links, they were helpful.
I was able to find exactly what I was looking for by using this link: https://www.youtube.com/watch?v=3ljoKaS6M9Q
I ended up changing the combo boxes to just two.

Thanks for everyone's help with this.