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.