Tables and Relationships Conundrum

[Gobbles]

I have a Purchase Orders table and I have a Purchase Order component in my Database. When we place a Purchase Order, although the relationships are with Purchase Orders table and Suppliers table, we would like to somehow link the Customers Job Card (why the parts are ordered) to the Purchase Order or the CUstomer Order to the Purchase Order so that we can write a query to put in a form so that the user can navigate from one Purchase Order record to the other and see what Purchase Order belongs to what Job Card or Order (either one is okay?) How would i do this. Currently if i link the Job Card to the Purchase Order PROBLEM: it gives a message that the record is required in the Purchase Orders so it doesnt save the Job Card, same goes if I create the Order ID in Purchase Orders. Have you got advice for me on how to bypass this problem or to achieve this form that shows the Purchase Order and Relating Order or Job Card. I have made sure the all tables are "empty" so that there is no clash with records and no records etc.

[Welshgasman]

Crossposted https://www.access-programmers.co.uk...ndrums.332982/

[Bob Fitz]

I have a Purchase Orders table and I have a Purchase Order component in my Database. When we place a Purchase Order, although the relationships are with Purchase Orders table and Suppliers table, we would like to somehow link the Customers Job Card (why the parts are ordered) to the Purchase Order or the CUstomer Order to the Purchase Order so that we can write a query to put in a form so that the user can navigate from one Purchase Order record to the other and see what Purchase Order belongs to what Job Card or Order (either one is okay?) How would i do this. Currently if i link the Job Card to the Purchase Order PROBLEM: it gives a message that the record is required in the Purchase Orders so it doesnt save the Job Card, same goes if I create the Order ID in Purchase Orders. Have you got advice for me on how to bypass this problem or to achieve this form that shows the Purchase Order and Relating Order or Job Card. I have made sure the all tables are "empty" so that there is no clash with records and no records etc.

Can you post a copy of the db

[NoellaG]

Maybe like this?