So far, I don't know :). If you mean that all availbale customer types should be collected in some 'lookup' table, it might be helpful.
>Ed ---
>
>For my edification, wouldn't you *still* need a join table of the customer types??
>
>
>>>Actually, No. But maybe I am not asking my question correctly. I have the data structures. I can handle forms,queries etc. My question has to do specifically with reports. If I have 500 customers distributed between class 1 and class 2. The method CalcAmtDue is different for each class. In a report I want to show the result of CalcAmtDue for each customer. How do I do it? Thanks...
>>
>>What prevents you from using simple way:
>>***CalcAmtDue method
>>LPARAMETER nCustid
>>IF SEEK(nCustid,"customer","id")=.F.
>> Return 0
>>ENDIF
>>IF customer.class=1
>>** one kind of calculations
>>ELSE
>>** another kind of calculation
>>ENDIF
>>RETURN nRetvalue
Edward Pikman
Independent Consultant