I need to return only the first instance of a matching record from a linked table.

 

Eg Table 1 linked to Table 2 using 'MemberNumber' field.

 

MemberNumber exists once only in Table 1 but multiple times in table 2.

I only require the MemberNumber returned for the first instance in table 2.

 

Any help would be greatly appreciated.

 

Regards,

 

John

 

 

I will also be returning a number of other fields associated with that first record (status, product, date and some more) and will need to sort all records on product. Further I then need to group them by product and perform a count for each of these groups.

 

I am only new to crystal but have used foxpro to do this sort of thing in the past. I think I need to find some way of skipping all records after that first one in the lnked table 2 so that it does not get returned at all.

 

I had been thinking about returning all fields to an array and using a formula to skip the subsequent records but thought there may have been an easier way.

 

 

Cheers,

 

John