multiple field index

[Kenneth Brody]

On 12/22/2015 4:40 PM, scooter6--- via Filepro-list wrote:
> I have created a file that can have up to 12 credit card transactions dated
> today or in the future...
>
> So each morning I want to send the current dated ones to be processed but
> think I'm having a brain cramp on this...
>
> I have 12 fields that are date fields (each shows as a1) Date of 1st Pmt
> a1) Date of 2nd Pmt, etc...then each has it's corresponding amount....
>
> How would I select records dated just today and grab the corresponding
> amount for that date?
[...]

Sort by A1).  Then, any reference to A1 will refer to the current instance 
of A1.  You could then simply put "if A1 eq @TD then select" in sort/select 
processing, and it will only select those instances equal to today's date. 
In output processing, A1 will refer to that instance as well.  Any reference 
to other A group members will refer to the corresponding instance.  (eg: if 
the third A1 is today's date, then A2 refers to the third instance of A2.)

-- 
Kenneth Brody