A report I'm working on has a one to many table relationship and I wish to hide the 'duplicate' records in the details section (not duplicate records in the true sense). I have a full outer join between two tables hldlnk.bib and sbn.number. Hldlnk.bib links to other tables to produce bibliographic information for a book (author, title etc.). sbn.number stores the isbn number for the book. However some books have two or more isbn numbers in the sbn.number table causing multiple records to appear in the details section.

Hi...Thanks for your response. Due to the use of the report I really need to keep the grouping as it is. What I'm wondering is can I use a formula to suppress these records - I have a field in the report itn.id which gives each items barcode and I would like to know if it's possible if this itn.id appears again to suppress that field and also the associated information that comes with that record (ie title, author etc. Basically remove that line from the report). I know I can suppress these at the format field level from displaying but this only removes that field and not the other fields for that record.