lookup

Steve Waters swaters at abiederman.com
Thu Mar 4 14:03:54 PST 2004


Thanks Courtney
That is exactly what I wanted!

-----------

Set up and index with both fields...then b4 lookup create a lookup key

Assuming part number is field 2

i.e. lk = 1<2

Just to be on safe side, make sure lk size is size of both fields...

lookup parts = parfile  k=lk   i=B -nx
index b is the combined fields...

-----------



Greeting,
I need to find how many part numbers have been received by month/yr.
I want to do a lookup to a file by date 0403 (yr,month - field 1).
If it does not exist do a lookup free. Then create file.
This is fine.

The problem I have is when the next @brk1 comes around
the file exists and is over written. What I need is for the processing
to look into field 2 (part number) if P/N is different then create a
new record. As I am getting this done I am finding myself writing a lot of
code.
Does some know a trick to do this with minimal code?

Can you do a lookup on 2 fields at the same time?

This is what the result should look like.

Month 0403 P/N 1234-0 Qty Received 34
Month 0403 P/N 5656-1 Qty received 5
Month 0403 P/N 7777-0 Qty Received 3
Month 0403 P/N A233-9 Qty received 78

Thanks for any help,
Steve




More information about the Filepro-list mailing list