One To Many Relation, How to make Add button show Existing User and not Create new one

Hello,

I have a table Users and a table Rooms

Users table looks like this: UserID, Name, Email, Room

Rooms table looks like this: RoomID, Name

So a User can be link to a Room via the Room column in the user table

Everything works fine, a user can only have one room, a room can have multiple users.

But in the room detail view, where it display the "Related Users" list, the add button want's to create a New user, where in my case I would like to only be able to link to an Existing User, meaning selecting the name of one of an existing user and then it will assign this RoomID to the selected User

Is there an easy way to do that ?

Thank you very much

0 0 17
  • UX
0 REPLIES 0
Top Labels in this Space