>You could use a subquery like this:
>(assumes a table of the desired customer codes -- CustCodes)
>

>SELECT rcm_pk, cmt_custname, rlc_number;
>FROM RailComp, RailCars, CustMast;
>WHERE rcm_rlc_fk = rlc_pk AND;
>rcm_custcode = cmt_custcode AND;
>NOT DELETED() AND;
>NOT rlc_final_bill AND;
>rlc_rectype = "R"  AND;
>rcm_custcode in (select custcode from custcodes);
>oRDER BY rcm_custcode, rlc_number, rcm_compdesc;
>INTO CURSOR WouSel
>

>Or you could join the 4 tables.


Thanks. I would first have to create and populate a table of selected customer codes,
but I think it would be better than ASCANning for each record.

Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people