See the data scenario below. I've successfully used the Master-Detail Form Wizard for tables A and B . Now I want to add table C as a sub/new form on the same page. There does not seem to be an easy way to gracefully do this. I've tried to add the a new form as a new region for Table C, updating the Where Clause therein, linking to the correct Table A field, but when I query the record the proper data is not retrieved for Table C fields. Does anyone have any suggestions on how to do this? I apologize if I've overlooked this exact scenario in the forum.
Data Scenario:
Table A (order HDR) :
Table B (order DTL) : has FK to PK in Table A
Table C (Customers) : has FK to non-PK in Table A