Page 1 of 1

Person relates to many Organisations - how to in Base?

PostPosted: Thu May 30, 2019 11:25 am
by Yumi
I have two tables, one for Organisations and one for People.
In my form I have the Main-form as Grid showing a list of Persons. Here I can select the person.
Then I have a Sub-form with the data-fields for this single person i selected.
On the right I want a list of all the organisations the person is active in.

For this task I created a 3rd table with the fields People ID and Organisation ID. In my form And in my form I created a 3rd Sub-form and another grid showing the Organisation ID. This is working.

But ID is just a number and not very intuitive, I would prefer to show the name of the organisation in the grid. Without typing the longish name into the 3rd table. The name is available in the organisation-table.

I have an obstruction in my head and can not think through how to go about.

Re: Person relates to many Organisations - how to in Base?

PostPosted: Thu May 30, 2019 11:43 am
by Villeroy
This is a many-to-many relation. Recent topic: viewtopic.php?f=13&t=98097