Data from Multiple Fields for search

[Dylan Carter]

This seemed so simple... but then it always does for us rookies

Here is what I want to to do. I have written a small invoice program. I may turn in 5 or 6 invoices to one client before any of them get paid. When they do get paid they are all paid with one big check. What I have done is create one file called "invoice: and one file called "check". The thought being that one I recieve a check I go to the "check" file, enter the date, check number, amount, blah blah, and also the invoice numbers that that check pays. Then I hit a submit button and it opens the "invoice" file and finds all of the invoice numbers from the "check" file, after that it would fill in information in each record based on the information in the "check" record (just check date and check number really).

The problem is getting it to do a find in the "invoice" record. The simplest way I could think of is having multiple find records (having a script that says "new record/request" works fine), what I can't do is get the information from the multiple fields (or one repeating - whatever) in "check" to be pasted in to the single field (but sequentialy on new records) of "invoice".

Am I going about this the hard way? what is the simple way to get the checks date and number to be pasted in to the corresponsding fields of multiple records in another file?

[Dylan Carter]

Since my last post is getting no love, I thought I would try to make the question simpler.

-->File "A" has fields 1a, 2a,3a and so on up to 10a (these could be separate fields or a repeating field, whatever works out better).

-->File "B" has field 1b which contains a unique number in each record.

-->I want file "B" to find 1 record for each field that contains data in the current record of file "A". If file "A"'s current record has data like (1a) 3367, (2a) 3379, (3a) 3382 - then I want file "B" to find three records with those same numbers in it's field "1b". If File "A" had 10 entry's then File "B" would find 10 records.

-->In a perfect world file "B" would then do a replace and replace the data in two of its other fields "Date-b" and Check Number-b" with the data from the current record in file "A" (field "date-a" and Check Number-a") - applying them to the found set only (obviously)

I got very close but it was cumbersome code at best. There must be a simple way to this. Containers? Lookups? Please any help would be great. I understand the logic needed, but can't find the code.

I thought there would be something that said "get data from file:field and put in file:field". If I could find that I could write a script that did that ten times with a "new record/request" in between and be done with it. Anyone?

[Oldfogey]

Solved your problem yet? If so, forget this.

I presume you have a Customer ID for each set of invoices? Create a third file for the check numbers. Link your invoice file to the chek file by invoice number and you have all the lookup-data you need.