Table reference question

[dragons life]

I have a database which tracks multiple vendors for multiple parts. I have
table one that lists the parts types (ex: Drills), table two that references
table one's part types (drop down box) then lists the part descriptions (ex:
Drills : ½†Carbide). I also have table three that lists all the vendor
info. All tables have a PK which is an autonumber.

My question is this:

How can I get a forth table to, from a drop down/combo box select the part
type then from a second drop down/combo box show those parts which fall under
the part type chosen from the first box?

Thanks in advanced.

 

[Evi]

You can't if you want to do this in a table with a lookup field. It needs to
be done in a form. Your database needs to be correctly designed.

I'm expecting to see a fourth table TblVendorParts
It would have its own primary key then
PartID linked from the Parts table
VendorID linked from the Vendors table
Fields which apply to that part when it is with that vendor
eg Price

You could only avoid this fourth table if each part is only stocked by 1
vendor.

Give the relevant field names of each table, indicating which fields link
the tables.
Evi