Two table, use one table to find items in other table

[chuckcou]

I know this can be done, but I am not sure where to begin.  Related Records only give me one item back.

I have:

• Table 1 has 50 records one field(part #)
• Table 2 has 10 records one field(part #)

I want to use table 2,10 records to find those records in Table 1.

So in the end, I will be seeing Table 1 with only those found records.  Thus max would be 10 records(if all were found) out of the 50.

[comment]

I don't think your question is clear.

Please do not use an abstract example.  Give your tables and fields meaningful names and explain what they represent and how they are related.

The task you describe is also unclear. What is the real problem you are trying to solve here?

[chuckcou]

Fair enough.

• Attached I have a Database called DATA
• It has two Tables: 1) NamesTable  2) Lookup
• What I want to do is have the NamesTable only show those 50 names found within the LookupTable.  Currently, the NamesTable shows 500 names.
• I do not want to go to the NamesTable and type 50 names into the find dialog box.  There has to be a quick way.

I think I would either need related record here or something with a script and find.

 

Data.fp7

[comment]

If you define a relationship between the two tables, matching on last_name, you can then use the Go to Related Record[] script step with the option "Match all records in the current found set" to create a found set of all records in the Data table where last_name matches one of the records in the current found set in the Lookup table.

Note that unlike performing a find, GTRR finds only exact matches. The other alternative is to use a loping script to load the last_name values from the found set in the Lookup table into a variable (or variables), go to the Data table and create a find request for each value.

 

Edited January 22, 2016 by comment

[chuckcou]

This is interesting.  Let do both.  

I have attempted to do both.

Related Record Script--I did a relationship.  I then did a script with related records, but nothing happens.  

Find Records Script-I think I am close on this one.  The only issue is when I run it the find will only bring back one record.  For some reason my loop does not seem to be working.

Thanks for your feedback and help.

Below is my current update file with both of my scripts.

Data.fp7

Edited January 22, 2016 by chuckcou

[comment]

I have fixed your scripts. The first one was using a wrong layout to display the related records. You should have seen this, because an error message comes out and tells you so. I couldn't understand what you tried to do in the second script - I rewrote it from scratch.

 

DataFixed.fp7

[chuckcou]

Regarding the Find Script Above-I think my issue has to do with I need to use Extend Found Set ?

[comment]

4 minutes ago, chuckcou said:

I need to use Extend Found Set ?

It's not necessary to use Extend Found Set when you have multiple find requests. Have you looked at my script?

[chuckcou]

Huh, that is interesting.  I will have a question, but let me see if I can do some leg work to figure out your find request.  P.S.  Thank you.

 

Yes, I am reviewing your script now.  Both work great.  Just working on logic so I can understand