Many to many relationship Account <-> Contacts

 
1
0
-1

Hi Everybody,

my scenario is this: one contact from Contacts table can be a contact for more then one account, and one Account may have more contacts. I created a form for the joiner table with contact_id and account_id foreign keys to manage the relationship between the tables Account and Contact. 

I followed the example of 'Many to many relationship', and everything is working, but the grid is populated with only the contact_id from the joiner table.

How can I populate this grid with more contacts fields like FirstName, LastName from the Contacts table?

Thanks.


  1. Anas Misbah Shami

    Can you share the application? Or a video?

    It's a little unclear by reading the text

  2. Fabrizio Frusone

    This is the app.

    When the app is running, click on the Account List, then click on the first account link, then the contact tab. There will appear only the contacts id. I'd like to show other contact informations.

    APP_lcm-4-20210621000439.jwa

CommentAdd your comment...

1 answer

  1.  
    1
    0
    -1

    Hi, did you try the sample app at the end of Many-to-Many Relationship Form Design?

    1. Fabrizio Frusone

      Yes, I used it as a sample. 

      But I need to replace the select box with a grid.

      So, my form would be something like this:

      Is there a 'no-code' way to populate the contact form grid?

    2. Anders

      It should be possible. If you have an account ID column in your Contact table you should be able to use that as the foreign key.

    3. Fabrizio Frusone

      Yes I know, but in a many to many relationship the account ID column as FK is in the Joiner table, not the contact table. I have been able to populate the grid with the contact ID from the joiner table, but I don't know how to get  Firstname and Lastname from the Contacts table. 

      This is my diagram:



    CommentAdd your comment...