Current design:
Multiple tables and forms - Main form is "Contracts"
Have the following subforms: ContractingInfo, PayingInfo, ActivityLog, and LineItemDetails --- all are linked to the "Contracts" table with PK and FK
If, for example, I put the subform LineItemDetails directly onto the main form, the data is linked to the main form.
I don't visually like the subform on the main form however. I would prefer to have a button on the main form that will take me to the subform on a separate screen.
When I do this, the data on the subform is no longer linked to the ContractID on the main form (even though the PK from the main table is the FK on the subform table).
Question: how do I get the subform on a separate page and access it via a button on the main form and still keep the data linked?
Multiple tables and forms - Main form is "Contracts"
Have the following subforms: ContractingInfo, PayingInfo, ActivityLog, and LineItemDetails --- all are linked to the "Contracts" table with PK and FK
If, for example, I put the subform LineItemDetails directly onto the main form, the data is linked to the main form.
I don't visually like the subform on the main form however. I would prefer to have a button on the main form that will take me to the subform on a separate screen.
When I do this, the data on the subform is no longer linked to the ContractID on the main form (even though the PK from the main table is the FK on the subform table).
Question: how do I get the subform on a separate page and access it via a button on the main form and still keep the data linked?