Jump to content

Don’t want to display duplicated record in portal


hung pham

This topic is 8304 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 8304 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.