Help with a relationhip issue in my database.
I have a business with multilple suppliers each supplier has multiple plants and each plant has a wide range of materials I purchase. I created a "suppliers" table with a portal leading to a "plant" table which has a portal leading to a table "materials" listing all their materials and prices. This seems to work well for me. My questions is how do I get the material information onto a table called "Job work sheet". For example when my employee opens a new work sheet and wants to enter the material he used on that day. I can get to one table ok but to draw up the particular material going thru the other two tables I am having problems.