I have :

1 contact file

1 company file

which is a many - to - many relationship.

My problem is this:

If fred is related to company 123 and company abc and at each of these companies he has a different email address.

So what I need is a file that is related to both the company and the contact in order to display the different emails?

Can anyone help me on how this relationship is established?

I started by creating a new file

Which will contain both an ID for the contact and the company but how to a relate this to the contact file so that clicking on different companies in a portal they will display the related contact details?

-------------------------------------------------------------

edit: a new idea was to create a field in the both files contain

CompID "

You should make a Company-Contact join file that has key fields CompID and ContactID. Then add other fields for information that is unique to each Company-Contact record, like email, positon, and phone numbers.

You can make relationships like this:

In Company, Company_Contact: Company::CompanyID = Company_Contact::CompID

In Contact, Company_Contact: Contact::ContactID = Company_Contact::ContactID

In Company-Contact: Company: Company_Contact:CompID = Company::CompanyID,

Contact: Company_Contact:ContactID = Contact::ContactID

If you want to create Company-Contact records through a portal in Company or in Contact, check the box on the Company_Contact relationship definition to Allow creation of related records.