Don’t want to display duplicated record in portal

[hung pham]

Let’s say I have a master file A and a related file B

A and B related by a field called ID

In a layout of A, there is a portal to display records of B.

Also in B, there is a field called Org Code. If Org code is duplicated (within a ID), then just display the first reccord in the portal.

For example:

B file:

ID Org Code

1 ED01

1 D10

1 ED01

Then the portal should be look like:

ED01

D10

Please help and take you in advance

HP

[BobWeaver]

I haven't tested this, but I think it will work.

In file B create a calculated field OrgCodeID = Org Code & "" & ID,

and then create an autoenter serial number field: SerNo

Make a self join relationship "SelfByOrgCodeID" on the OrgCodeID field.

Create a calculated field UniqueID with this formula:

case(SerNo=Min(SelfByOrgCodeID::SerNo),ID,"")

Then use UniqueID in the portal relationship instead of ID.

[Edit: changed the selfjoin field definition]

[ July 03, 2001: Message edited by: BobWeaver ]