Relating Multiple Contacts to One File plus

[GHT]

I recently asked for a solution to my problem and received an excellent solution from John Mark Osborne, using a join file. However, upon implementing this soution I discovered that I needed another option...here it is:

I have a contacts database with a unique client ID. I have a projects database with an ID that I want to relate several contacts to and be able to view the projects through a portal in the client's file.

I have now run into a situation where I may have several clients working for one company and I want to have a portal that will show any project related to the company name as well as the person working for that company.

How can I accomplish this?

Can someone offer me some guidance?

Any assistance is greatly appreciated.

Thanks

Edited May 25, 2006 by Guest

[comment]

Assuming a client is related to a company, and company is related via a join table to projects:

1. Place a portal to the join table on the client's layout;

2. Place fields from the join table and/or from projects in the portal.