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