There is a sales file with a varying number of lines, tab delimited. Each line records one transaction, the sale of one product. These lines accumulate throughout the day.
At the end of the day, I want to take (for instance) item 1 & tab & item 2 & tab, and use this to look up the line in the stock list that corresponds to that sale. Then item 5 of that line in the stock list, which is the stock level, should be decremented by 1 to show one of these items has been sold. And so on for each line item in the sales file. Not sure if this is quite clear, so here it is a bit more specific. The sales field might look like this: 1 XX 2.30 RRR 6/1/08 2 YY 4.20 RRR 7/1/08 where the items are number, description, price, department, datestamp then the stock field might look like this 1 XX 2.30 RRR 100 2 YY 4.20 RRR 150 Where the items are: number, description, price, department, no in inventory. So what I am trying to do is go through the sales field using the number and description from each line, one after the other, and match each line against the record for that product in the stock field, then if there is a match, knock down the no in inventory in the stock field, which is item 5, by 1. If I could make it work, the result of running it in the above instance would just be that the no in stock would fall to 99 and 149. The sticking point is how to do this match and decrement using repeat. I can do it easily when dealing with it one record at a time - when there is only one record in the field, so there is no repeat loop. But I'm having great trouble figuring out how you do it when you have to run through a series of records from the first field one after the other against the second field Part of the difficulty may be the thing that was referred to earlier on the list, that you cannot modify the repeat for variable. Any thoughts or hints very gratefully received as always. Peter _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
