I have a Crystal report where the data is linked between two tables. In the lookup table there were two matching records, the first of which was marked for deletion and the second one, which was the one that I wanted. Crystal picked up the deleted record! I there some kind of setting in Crystal to ignore deleted records? Has anyone else run into this?
TIA