Person relates to many Organisations - how to in Base?

Discuss the database features

Person relates to many Organisations - how to in Base?

Postby Yumi » Thu May 30, 2019 11:25 am

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
Yumi
 
Posts: 23
Joined: Fri Aug 29, 2008 3:54 am

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

Postby Villeroy » Thu May 30, 2019 11:43 am

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 27873
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests