Hi,

I have a table with a primary key (Sales Number) related to lower table with one to many to Transaction Number

The Transaction Number will contain many products so is related to a table fpr products via one to many.

BUT - also transaction number is also related to another table via a one to many relationship for Invoices for which there could be many.

Now I have set up all relationships and the tables look to be correct.

But how do I get the transaction number to flow down the 2 relationships.

I can only at this stage link either Invoices OR products via the transaction number (prim key).

How can I set it up so that when I update / enter data into the transaction table, the foriegn keys in both INVOICES and PRODUCTS Table?

I need to set this up in a form too?

Can anyone help?

You don't do this at table level. Typically you would use a form/subform relationship and the parent/child links will ensure the records are properly related.