Jump to content

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

This topic is 2985 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 !!

Link to comment
Share on other sites

  • Newbies

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?


Capture d’écran 2015-12-20 à 15.04.15.png

Edited by YannickBouanha
Link to comment
Share on other sites

This topic is 2985 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.