Inner or outer Many to Many Relationship

[GWBjr]

I a

Above you will see that I have created a many to many relationship. In the Lenders table I have 101 records. In MSAs_ I have almost 1000 records. How do I build a data page based on the MSA_Lender_Offering where I see  1 one of the Lender records and all of the MSAs_ records so that I can select which MSAs_ the Lender offers.

[Vitalikssssss]

Hi @GWBjr,

I assume that you would like to populate the table "MSA_Lender_Offering" with all possible combination of ID`s from "Lenders" and MSAs_ tables.

If my assumption is correct than you can use Tasks to achieve this.

Here is an example of Tasks which populates all possible combination of ID`s from Table_A and Table_B.

Hope this helps.

Regards,

vitalikssssss

 

[GWBjr]

Thank you but what I want is for each Lender to select all MSA_lender_ offerings that they offer. I don't want MSA_lender_offering to be pre-populated. To select, the lender must be able to see all of the 101  MSAs_1 offerings

[GWBjr]

All I want is a Grid edit report that I can send to my lenders. See hand drawn depiction below.