making relationships for query

[fullymooned]

I have 5 different tables and all have 3 fields common to them. I need to make a form so that I can pull out certain fields from each table. I have tried to make a query and use it to make a form but because the tables have 3 fields in common, I have got stuck. I need to make a form such that there is one input field for date, time and shift which are the common fields and they get stored in their respective tables.

thank you

 

[Joe4]

As long as you set up the relationships in your query correctly, it shouldn't matter how many fields the tables have in common (I have down 3 before without any problems).

If you are still having problems, please list the key fields of each of the tables and describe how they should be linked.