Price calculation trouble

[BobWeaver]

You are using repeating fields. Not a good idea. But, to answer your question, if you mix non-repeating and repeating fields in a calculation, you need to put an Extend() function around your non-repeating fields. For example, if Qty and UnitPrice are repeating fields, and the SalesTaxRate is a non-repeating field, a tax calculation would look something like this:

Qty * UnitPrice * Extend(SalesTaxRate)

I recommend that you look at replacing the repeating fields with a portal to a related line items file.

[rh512]

Hi. I am working on a Quote database, linking the prices of a Customer Prices database to it. The Customer Prices DB has several fields of items, which all have distinct prices. In the quote database, I have a popup menu for the product. When the user picks a product, I want to pull that particular product price from the customer database for a particular customer. Now...all of my calculations work fine...but only for the first row. It will pull the record with no problem, I just can't get it to do the same in the following rows (which are the same field, repeated). I can't figure out how to adjust this. Also, I have other calculations, which are case statements, but they do not pull from another database, and these calculations work fine in the repeating rows. If anyone could help I would be grateful!! Thank you!!!