As the title suggests, I’m wondering if it’s possible to link an existing record to another when there is an N:1 relationship.
For example, let’s say I have two tables: “Car” and “Parts”, where the relationship is N:1—meaning one car can have many parts. I know that parts can be added to a Car record by opening it and clicking the plus sign in the Parts field within the form. However, is there a way to create the parts first and then link them to a car afterward?
I understand that this can be achieved through code, but I’m looking for a more user-friendly solution. Is there a UI component—such as a dropdown or another selection tool—that would allow users to manually assign existing parts to a car?
Yes, that’s correct. However, the challenge is that I have to open each record individually to link them. I’m wondering if there’s a way to select multiple existing records at once and link them in bulk, rather than doing it one by one.
In the example above, this would mean: Can I open a Car record, view all Part records that are not yet linked to any car, and select multiple parts to associate with that “Car” record in one action?
The use case for this would be if we were to import all the “Part” records from some source and now we wanted to link them to a “Car” record.
I understand. Unfortunately in the no-code variant it is not possible. As you mentioned, it is possible using script. But I’ll try to discuss the idea with my colleagues at the product meeting and if we should consider improving the UI in the future.