• Registered: 2017-02-01
  • Posts: 106

Topic: Tablegrid and n:m Relation

Hi,
I have a little question.
For a software I have some table. Two of these tables have a n:m relation.
.
Example:
.
A) One person can work on many projects
B) One project can have many persons who are working on it
.
My question is, how can I create a tablegrid who shows me all projects a person is working for and when I click on a project at this table grid the person table grid should change and show all persons working on this project.
.
Early planing stage, no examples created yet because I do not know how to handle this question.
Thank you.

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,686

Re: Tablegrid and n:m Relation

Hello Teco049,
The attached project might give you some ideas.
Rather than have one tablegrid changing to show another tablegrid, I have done an example showing 3 tablegrids that are linked.
But if your design is such that you need to place one tablegrid on top of another, it is not a problem (the processing logic is just the same as in my example).
I hope this helps,
Derek.

Post's attachments

Attachment icon techo manytomany.zip 339.61 kb, 396 downloads since 2017-07-07 

  • Registered: 2015-02-24
  • Posts: 446

Re: Tablegrid and n:m Relation

Nothing to add smile


This is exactly the way to do it : to main tables and a relation table in between.


Cheers


Math

I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor