relate How to, on the layouts, relate two many-to-many records

[YannickBouanha]

Hello community, 

I have two entities, that have a many-to-many relationship.

I have my Computers entity, and a Users entity. One user can have many computers, and one computer can be used by many users.

I created my Computers and Users tables, plus a join table to have the relationship. The tables are OK, and work fine, I manually tested with setting IDs.

My problem is that, on the layouts, I don't know how to technically and concretely relate two records from each table. I tried with external portal, but when I tried, it also creates records that I don't want.

Simple: I would like to be on the Computers layout for example, and set a field so this computer is linked to one given user. And the opposite.

With what tools can I do that. What related field to put on which layout so I can relate a Computer with a User.

Thanks a lot for your help !!

[David Zakary]

If the Computers table is the base table for the layout, a portal based on the Join table which contains fields from Users should do the trick.

[YannickBouanha]

Hi David, thanks for your reply, that's an idea I did not have.

Take a look at my tables. As you can see, I have only 2 ID's in my join table.

I've just tried that, but the portals seems to be read only, even if set up "authorize record creation via this link" in both side.

Have an idea of something to activate?

 

Edited December 20, 2015 by YannickBouanha
error

[comment]

59 minutes ago, YannickBouanha said:

I would like to be on the Computers layout for example, and set a field so this computer is linked to one given user. And the opposite.

See if this helps:
http://fmforums.com/topic/50942-portal-grouping-problem/?do=findComment&comment=239210