Ask for a FK in an entity

0
hi sorry for my english, So I’m trying to connect 2 entities. For example in one call ‘Boss’ I want to see on what companies he is handling, So if a select a different boss I want to see another companies, is like searching his foreign key, I added in the model, so the problem I don’t know how to handle that, if I can put a condition over the List View with the model.   Thanks you.
asked
1 answers
0

Assuming you have 2 entities Boss and Company and an association between the company and the boss as * to 1.

This means a company has 1 boss and a boss can refer to multiple companies.

Create the overview and edit pages for both the entities. On the Company NewEdit page the boss can be selected with the reference selector, essentially assigning the boss to the company. Once this data is available you can add a datagrid inside the dataview of the boss NewEdit page and show the information of the companies by selecting the company over association. The on the boss page you’ll see the companies for that boss.

In Mendix FK’s aren’t used all associations are created in link-tables storing the key (id) from the left and right tables (entities).

Hope this helps in finding  your solution

answered