Jump to content

Help with relationship owner to company


JUWL233
 Share

This topic is 2883 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

 

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

This topic is 2883 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.