Help with relationship owner to company

[JUWL233]

Hi I'm new to FM. I'm trying to create a database showing a person who owns multiple companies. I've created 1 table for Owner and 1 table for company. In the Owner Form, I need it to show the owner details and the list of companies he/she owns. I also need a way to add new company name to the Owner Form that can reflect on the Company Form.

 

On the Company Form, i need it to show the Owner and Shareholders of the company. Thanks in advance.

 

 

[Lee Smith]

Hi JUWL, and welcome to the FM Forums,

 

I’m amazed that FileMaker Pro v7 works on Yosemite. Are you sure you are not using  FileMaker Pro 11, all versions of FileMaker from version 7 through 11 use the same file extension of fp7

 

Have tried to make this relationship  work? Why don’t you attach a copy of your file so we can see what you have so far?

 

To attach a file, it must be Zipped. Here is a link that show the steps to attach a file ATTACH A FILE

[bcooney]

Many data models exist for this:

1. People> roles< Companies where the table Roles would have the foreign keys, id_person, id_company, id_role_type

2. Party ( with subtype tables: Person and Company).

 

Party>Party Relationship<Party Relationship Type

 

where Party Relationship has the keys: id_party_from, id_party_to and id_relationship_type (optionally, from and thru dates, comment).

[JUWL233]

Thanks for your reply Lee Smith and bcooney.

 

I'm using FM Pro Advance 12. I'll attach the sample file and maybe u guys can help me out. Thank in advance.

Contacts.fmp12.zip