David,

Instead of using ODBC you might be better of by prepering your report data in a FOX2X table and use that one in your Cr report.

Walter,

>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