Hi All,

I have a local view that I am trying to get rid off by replacing it with cursor. My local view (MaxData!CCRejectReasons) has two tables in it (1.) Free Table - RejectReasons.dbf (2.) MaxData.dbc Table - ComCodeReject.dbf. The RejectReasons.reason_id is INNER JOIN with ComCodeReject.reason_id.

RejectReasons.dbf has two fields - reason_id and reason
ComCodeReject.dbf has two fields - reason_id and comcode

Is this possible? Please help.

Thanks,
Sam