Cross Table Lookup

[whynot]

Hi,

What I'm trying to do is perform a pattern match across tables as a way of aggregation. Basically, when a user enters a date range, it matches against a specific set of hourly records, performs a PatternCount() on a specific field, and returns the date of the record if the pattern is matched. However, I can't figure out how to aggregate the result of the if() statement in such a way that all the dates are returned to the first table.

Let me know if any of this is unclear; thanks so much for any help you can give.

--whynot

[Fenton]

Since you say PatternCount() it sounds like you'll need to use Go To Related Records to go to the records matching the date range (a compound date relationship?), then Loop through them, gathering your dates, then return.

If your PatternCount() could be set up as part of the compound date range relationship, then you could get them directly (well, kind of), using the ValueListItems(), using that relationship to filter the target field. But that's unclear.

It would help to know: 1. What the PatternCount() is doing, and whether it could be included in the relationship, and 2. What exactly you mean by "returned to the 1st table"? Into a global field?, 3. How are they entering the date criteria, also global fields? Or a Find?, and 4. Where is the If?

[whynot]

Thanks ever so much,

But I managed to figure out the solution using a script. (Before I was trying to do one involving in table calculations and intertable relationships; I'm sure I could have gotten it to work, but the script was much easier.)

-- whynot