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.
Person relates to many Organisations - how to in Base?
Person relates to many Organisations - how to in Base?
OOo 4.1.6 on Linux Mint 19.1 Tessa
Re: Person relates to many Organisations - how to in Base?
This is a many-to-many relation. Recent topic: viewtopic.php?f=13&t=98097
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice