first if you only want records that match between the two tables make it an inner join, if you need records gfrom table A with no match to table B make it an outer join between the two tables.
as for 'removing the duplicates' you won't actually remocve them, you just hide the duplicate content. Removing them removes all the 'notes' too.
Option 1:
group on the primary key from table A (likely the TransactionData field)
place the records from Table A in the group header (dispalys once) and place the Notes from table B in the details (displays once per row of data)
or
place all fields onto deatail section and under the field properties select 'suppress if duplicated' -this will reset on the change of the group
Option 2:
Order by the primary key in table A
place all fields on the detail section
conditionally suppress all the data you want to by using a suppression formula
example:
next(tableA.primaryKeyfield)=tableA.primarykeyfield)
IP Logged
