Jump to content

multiple criteria filtered portal


toddj
 Share

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

Recommended Posts

I can't figure this relationship procedure out...

I have two occurences of the same table: AllParts and SomeParts.

I want a portal (showing SomeParts records) to list only the parts that meet certain user-defined criteria the user has set using global fields.

For example, the user selects color="green" from a pop-up, category="bolts" from a second pop-up, and vendor="acme" from a third pop-up. So I want the portal to show only the green bolts sold by Acme.

Here's what I tried unsuccessfully:

- added a global "criteria" field that contains a shorthand code for the user's selections.

- added a calculated field that generates the same shorthand code for the record's properties

- created a relationship between the two table-occurences that matches the allparts::global to the someparts::calculated fields.

I can see the fields contain the correct values and should have plenty of exact matches, but nothing shows in my portal. :)

Am I going about this wrong way?

Link to comment
Share on other sites

This topic is 5648 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.