Jump to content

show subset of portal?


rcliff
 Share

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

Recommended Posts

  • Newbies

Hi all. I'm not sure if this is possible but I'm hoping one of you gurus out there can confirm.

I have a portal in DB1 which displays the contents from DB2 based on a shared ID. When you type in any given ID the portal will show the following wherever there is an ID match.

Portal-Row-1 DB2_Field_A DB2_Field_B DB2_Field_C

Portal-Row-2 DB2_Field_A DB2_Field_B DB2_Field_C

Portal-Row-3 DB2_Field_A DB2_Field_B DB2_Field_C

Etc...

Nothing fancy and it works fine but the only trouble is it shows all records that match the ID and I want to be able to show a subset based on a user selection. Is there a way to limit what the portal will show based on a additional secondary value. For example, could I show the records only where there's an ID match and a user selects some additional criteria such as DB2_Field_A=X.

Thanks in advance for any suggestions.

Link to comment
Share on other sites

Yes this is possible.

In the transaction file, create a calc field, that test to see if

DB2_Field_A=X, if so then display the Shared ID Field.

In the main file create a relationship between the Shared ID field

and the newly created field in the tx file.

Note since the field is calculated in the tx file you won't be able to

add records through this relationship/portal.

Link to comment
Share on other sites

  • Newbies

Stephen, thanks for the reply. BTW, this is a really a great site with a wealth of information.

Anyway, in my case data is entered through the portal so the solution you suggested will not work. Also, the X that the users select is a date.

Any other thoughts on how to do this or is this not possible?

Thanks again

Cliff

Link to comment
Share on other sites

How about a second relationship and a second portal to go along with it?

You can get really tricky by creating fields on which to base the 2nd relationship, then have a script set the fields of the found set to the correct ID. I'm skipping quite a bit, but I think you'll get the idea (besides, it's late Sunday night as I write this, and I was traveling all weekend, and I'm beat, so there).

Link to comment
Share on other sites

This topic is 7201 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
 Share

×
×
  • Create New...

Important Information

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