I have set up a relational database, one a product database that stores the SKU; description; price. Another database with order info such as name; address; etc, and the three previous fields related from the products database. And a calculation field names total which calculates price*qty. The field all work fine except for this one which turns up 0. Does anyone know why this is happening? if this is not enough information please email me. [email protected]

------------------

Rich

How do you get the price from the original file to the file with name, address, etc? Is it a lookup? Calculation? If calculation do you have the result set to number? If it's text it won't work. Is your price field set up as a number field and not a text field? There are many things to consider with this problem. Yes we'll need more info. But first remember this, anytime you do calculations you need a field that is set as a number. Check the fields associated with this calculation and make sure they are number fields or pre-existing calculations.

Ryan

[email protected]