Filtering Portal Results

[Sammy]

I call a set of records in a portal by defining the rel Date::Date , having a global that allows me to enter any date I want.

Here's my problem: Once I have all of the records defined, I would like to filter more specifically, and to perform some calculations off of the displayed records. For instance, I would like to display in my portal records that are from one day (Date::Date), but filter those to show only the records that are in a specific facility (Location::Location). Is there any way I can use multiple relationships to do that?

[Kurt Knippel]

In main file:

2 globals: gDate and gLocation

1 calculation: cFilter = DateToText (gDate) & " " & gLocation

In related file:

1 calculation: cMultikey =

Location & "<paragraph symbol>" &

DateToText (Date) & "<paragraph symbol>" &

DateToText (Date) & " " & Location

Setup your relationship as cFilter::cMultikey.

This way what you type into either or both fields will filter the portal.

[Sammy]

Okay, I set that up, but I'm having trouble making it work. What I get is the portal displays only one entry via the relationship, it is not a record that should be displayed (ie the record's date matches, but the facility is incorrect), and it repeats this record 50-60 times inside the portal. If I take out the facility and leave just the date, it still displays that same record, but shows only 10 or so repeats.

Any thoughts?

[-Queue-]

Duplication of rows in a portal usually indicates that the fields in the portal are not using the same relationship as the portal.