Hi,



I have 4 tables. 3 of these tables (tables A, B, C) have a one to many relationship with the fourth table (table X).

In each case, table A, B, C form the one side of the relationship and table X forms the many side of the relationship.

I am confident about setting up table A,B or C as the main form and using table X as the subform.

However, ideally I would like a form that has all three tables (A,B & C) forming the main form and dictating which records show in the table X subform.

My underlying reason for doing this is so that I can add new records to tables A, B, C without having to open multiple forms. Table X should then be able to use these new records for its own data input.

Advice on the best approach would be much appreciated

Many thanks in advance. RubberStamp