Multiple Finds w Linked Tables

[Richard_N]

I would like to create a script that will take all the records from Table_A and create a find request for each in Table_B.

The user will enter their request in Table_A as a temporary file so that they can evaluate the data prior to submitting the find request (like a shopping cart).

If someone could point me in the right direction as what script commands would be best I would appreciate the help.

R

[Robert Kidd]

I would be looking to use the "Go To Related Records" script step to move from your found set in table A to matching records in table B

[Richard_N]

I agree the goto related record is probably a path to my solution, but I need a little more detail. I can relate the two tables with a constant global field but what script steps do I use.

Table_A will be my master file(3000+ records) in which I will perform the find operation. Table_B will be a temporary file that the user will add part numbers that he/she would like to search for. When in Table_A the user will run this script that looks at each record in Table_B and finds each occurrence in Table_A. When the search is complete and reports generatee another script will run to delete all records in Table_B leaving it ready for the next search.

I presume I will need to setup a loop,use the SetField, and a counter to determine when all records in Table_B have been processed through the create new find request.

Basically it is like a shopping cart on the web. Fill the cart with your desired items, provide options for adding quantity and deleting line items and then proceed to checkout.

Suggestions with sample script steps would really help me resolve this.

Thank for listening.

R

[Fenton]

Here's a little file that implements your idea of a temporary table for choices. It uses the Go To Related Record [ relationship, Matching all records in found set ] option.

It uses a constant self-relationship in the Choices table, with "Allow creation of related records" to create new choices, in a portal (which is the same for all records).

There's some extra stuff in the file, a Globals table, in order to produce a global trash can ONLY on rows with data.

Self_Choices.fp7.zip

Edited May 31, 2007 by Guest

[Richard_N]

This looks what I need. I'll check it out more closely tonight. Thanks for your help!!!

Rich