hi,

when i run my report, the following table is produced:

cust# age status
123     21      in
123      21     out
123      21      out
123      23      up
123      21      down
124      21      out
126      22       in
126      22      out
126      21       up

(i believe the reason i am getting duplicate records for the same cust#, is because i am linking 2 db tables by cust#. as you can see there are multiple records in the second database (which contains the 'status' field) for every cust# in the first database.

what i want to produce is the following:

cust#
123     etc
124     etc
126     etc ( so the distinct records option when i click on 'database'->'distinct records' is selecting the distinct records based on the cust#)

what i am getting is:

cust# age status
123      21     in
123      21     out
123      23      up
123      21     down
124      21     out
126      22       in
126      22      out
126      21       up

so now whats happening is the distinct records option, is selecting the distinct records based on the 'status' field.

How to do set it so that when i click on 'database' -> 'distinct records', It bases the distinict records on the cust# field ?

thanks

j