AnsweredAssumed Answered

Is it possible to place two portals on the same layout?

Question asked by johnsmith_1 on Jan 21, 2011
Latest reply on Jan 25, 2011 by philmodjunk

Title

Is it possible to place two portals on the same layout?

Post

Hello,

I know that this question has been asked before but I couldn't get right the trick behind the solution.

Maybe some indulgent fmpro advanced user could patiently share some knowho with me.

Is it possible to get different data on two portals on the  same layout based on the relationship established between two tables  through a joint table?

If the answer is yes I would appreciate guidance on how to do it.

My table stettings are as follows

Document table

__pkFID

other fields

Person table

__pkPersonID

NameFulList

NameFull

NameLast

NameMiddleInitial

NameFirst

PersonJobTitle

PersonrDepartment

other fields

Appraisal (joint table)

__pkAppraisalID

_fkFID

_fkPersonID

NameLast

NameMiddleInitial

NameFirst

The Appraisal joint table was created to sort out the many-to-many relationship between Document and Person tables.

The relationships so far established between the TOs are as follows:

Document to Appraisal (one to many): Document __pkFID::Appraisal_fkFID

Person to Appraisal (One to many): Person__pkPersonID::Appraisal_fkPersonID

My objective is to record both the reviewers and approvers on each document. To achieve this, in the Entry layout of Document table I have a tab named Appraisal where I have put two portals one for the reviewers and another for the approvers.

Since the two portals should have different values, I wrongly assumed that the solution was to create another TO for the Person table and establish the adequate relationships, but it dindn't matter what I did becuase I was always getting the same values on both portals.

What I tried and din't work was to create a new TO for the Person table. I named it Person 2 and established a relationship with the Appraisal joint table.

My idea was for one portal to get the data from the Person -> Appraisal realtionship and for the other portal to get the data from the Person 2 -> Appraisal realtionship.

But no matter how I set up the fields on both portals I was getting the same values on both.

What do I have to do to achieve this?

Thanks,

fmnovice

Outcomes