Store Find results then Find in an unrelated table?

[Rich S]

Greets, and I hope you're all still around after May 21 or I'm sunk.

(This probably belongs in the Script forum but here goes...)

I have a field, Table1::NameLastFirst, that contains the last and first name of people. After performing a Find in this field so I have a found set, I'd like to go to an unrelated table (Table2) and perform a Find using the names in the found set from Table1 to pull up the like-named records in Table2. How do I do that? I suppose that I could relate the two tables using NameLastFirst as a key field, but I'm still stuck with the same problem of how I can accomplish this monumental task.

TIA for your help!

Rich

[bcooney]

Many things I don't understand with this Rich.

First of all, are Table1 and Table2 in the same file? If so, why not have a People table that is used across the system?

Second, the same find criteria should work with this identical fields, so what exactly do you feel you're accomplishing by even doing a find in Table1?

[comment]

I suppose that I could relate the two tables using NameLastFirst as a key field, but I'm still stuck with the same problem of how I can accomplish this monumental task.

By doing GTRR [Match found set]. Keep in mind that with a large found set this may take a while. The other option, of course, is to loop among the found records to collect the names, then create a find request for each name in the collected list.

Like Barbara, I too wonder this is about.

[comment]

I hope you're all still around after May 21 or I'm sunk.

I didn't know what this referred to, so I had to look it up. So, you presume we won't be around - but you will?

BTW, it's amazing how some people can tell you the end of the world to the minute, while the best the cable company can do is "between 8:00 to 12:00".

[Rich S]

Sorry for the delay--personal matters. Please refer to the attached file. Use lowercase "admin" for both the username and password.

I inherited this solution which, unfortunately for me, is coded using the anchor-buoy T.O. set-up; I'm having a difficult time sorting that out since I have no experience with it...and naming the tables People and Family isn't helping. (What a bad name choice for the tables since they can be easily confused. Last time I checked, a family consists of people.)

Anyway, back to the Find problem. If you were to click on the Families tab (FAMILY_Form layout) to perform a Find for say, family last names that begin with S, you'd have a found set of "x" number of records. What I want to do is take that found set and use it in the script ListByFamilyName where if the user chooses All then all the records from the found set will be used in the report.

The problem is that there are two different tables: FAM (owns the FAMILY_Form layout) and PEOPLE (FamilyReport layout) where the report lies, so on the surface I can't see how it's done. :S

FWR 2011 Database 5-19-11 copy.fp7.zip

[comment]

Well, "people" are individuals and "families" are groups of individuals, I guess. I've taken a look at your file. I suggest you post a simple one that isolates the problem.