Sammy Posted September 17, 2004 Share Posted September 17, 2004 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? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted September 17, 2004 Share Posted September 17, 2004 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. Link to comment Share on other sites More sharing options...
Sammy Posted September 20, 2004 Author Share Posted September 20, 2004 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? Link to comment Share on other sites More sharing options...
-Queue- Posted September 20, 2004 Share Posted September 20, 2004 Duplication of rows in a portal usually indicates that the fields in the portal are not using the same relationship as the portal. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7332 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 accountSign in
Already have an account? Sign in here.
Sign In Now