Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How am I supposed to do this?
Message
From
12/11/1998 13:23:59
 
 
To
12/11/1998 12:52:57
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00156920
Message ID:
00157051
Views:
36
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
Previous
Reply
Map
View

Click here to load this message in the networking platform