Person relates to many Organisations - how to in Base?

Discuss the database features
Post Reply
Yumi
Posts: 26
Joined: Fri Aug 29, 2008 3:54 am

Person relates to many Organisations - how to in Base?

Post 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.
OOo 4.1.6 on Linux Mint 19.1 Tessa
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Post by Villeroy »

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
Post Reply