May 25, 200619 yr 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, 200619 yr by Guest
May 25, 200619 yr 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.
Create an account or sign in to comment