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