Auto link to N:2 root table
Hi,
I'm doing a table to keep track of the successive persons at a certain Function in companies.
Therefore, I have a Company table, linked to a Function table, linked itself to a Contact table.
I'd like the Contacts records to link automatically to the Company table. Currently it's only linked to Function, having to linked manually to Company?
How to do so, please ?
Looking forward to hear from you.
Regards,
3 replies
-
Just my two cents, but it seems like there should be a direct link between Company and Contacts then a N:N link between the two called Function. This way you can track specific data for that person at that function, i.e. start/end dates of when the person had the function. This also allows you to have multiple people at the same function.
If you don’t need that level then you can make a dynamic choice field in Contacts called Function
-
said:
To be clear, my first purpose is to track lenght of rotations at a post rather than people.To be clear you have a 1:N between Company and Function, where 1 company record can be linked to many Function records. Then you also have a 1:N between Function and Contacts.
This current setup forces you to have multiple records with the same Function name for each company since a Function record can only be linked to 1 Company record. I'm guessing a Function can exist in multiple companies. You don't want to be entering multiple copies of the same function just so you can link to a different company. This alone calls for a third N:N table between Company and Function.
This turns the Function table into a root table of Function names that you use in the new N:N table, either through a relationship field or a dynamic choice/multi field. You can then add a new Function record and that Function becomes available to all Companies.
Content aside
- 1 yr agoLast active
- 3Replies
- 73Views
-
2
Following