I have this situation. Will try to simply explain it
Tables - A B C (Database expert used - joined by a matching key, with A driving table)

B and C has multiple records for matching key ( B has 2 records for each record in A and C has more than 2 records for each record in A)



My question is how to

1. Write formula in selection criteria to exclude records from getting selected (using selection criteria formula) if value of a field in table C has a particular value (i want entire recordset NOT selected not just the records with this value).

2. Suppress duplicate display for records.



Data selected for A.id = 1 will look like this



A.id    b.b_id     c.c_name
1       2              ABC
1       2              XYZ
1       2              PQR
1       3              abc
1       3              xyz
1       3              pqr

what I want to do is, exclude this records from getting selected if C.c_name = PQR, also for other records I want to suppress duplicate display of records i.e display one record for b.b_id = 2 and b.b_id = 3 (no need to display any field from table C)



Thanks in advance.

Edited by ansehnlich - 27 May 2010 at 7:04pm