Help needed calculating fields 
Author Message
 Help needed calculating fields

I'm having some difficulty calculating prices in a multi-table database.
The problem is that part of the information needed to compute prices
is held in the parent table (ORDERS) while the remainder is in the
detail lines (DELIVERY).  My data model looks like this:

        ORDERS =====> DELIVERY

It's easy enough to compute the price when entering a delivery.
i.e., PRICE = DELIVERY.MILEAGE * RATE + ORDERS.SURCHARGE

My problem comes when the data in the ORDERS table changes.  How do
I update the price for every item in the DELIVERY table?  Paradox
does the right thing with calculated fields, but I need to save the
results in the database (in case the prices change, for example.)

Is there a way to use calculated fields but store their results in
the table?

                                -- Rassilon



Sat, 24 Aug 1996 00:26:22 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. need help with calculated field...this is a tough one

2. Need help with calculated field

3. Help with calculated field needed

4. HELP Needed with Calculated Fields

5. Help - Calculating With a Calculated Field

6. Calculated fields - need help

7. Need Help with Calculated Fields!

8. Par 7: Need help with calculated fields!

9. Need help using dates in calculated report fields

10. Need help with calculated field in BROWSE

11. calculated field based on another calculated field

12. Storing calculated fields vs calculating on the go


 
Powered by phpBB® Forum Software