4 table relationships

Hello all,
I'm trying to get a one to many relationship between four tables. Each
table is embedded within the other. The process I wish to accomplish is to
have my primary table with the primary key pull data from another table, the
linked table will then pull data from another table linked to it. My problem
is I need to be able to have indexed keys but multiple entries. Basically The
first table can have only one work order, the next table can have many item
numbers based on the work order, the last table wil have many layer numbers
based on both one work order and the many item numbers.
I have tried junction tables and using primary keys. Neither have worked
for me. Any ideas will be very helpful.


Thanks Bill