Repeating Fields calculation error pls help....

[Cobalto]

Price field on a repeating filed ..

I have 2 DB

Prices database:

Part number:

Retail:

Price 1: $100

Price 2 to 5: $90

Quotes Database:

Qty: Repeating Field

Part Number: Repeating Field, has a relationship with the Price DB.

Description: Repeating field, lookup. (works ok)

Price:repeating field( I need field to retrive the correct price in the relation to the amount they get) I can only makte retrieve trhought a lookup the retail price and when I put a calculation y only calculates the first item.

Both files are attach...

Thanks for all the help in advance.

[Søren Dyhr]

This is not a task for repeating fields, use relations!! When conversion haas taken place use case( statements.... BTW why post this in containers???

--sd