calculation problem

[kristlek]

I have an Orders database that is related to a Price List database by product id. In the orders database, when I enter the product id (repeating field), the wholesale prices (repeating field) and the retail prices (repeating field) should be entered automatically. This only works for the first row. I tried the extend function, but it doesn't work. I also tried using a portal which didn't work.

What am I missing? Any suggestions?

kristlek

[FUBAR]

I'll take bets on how many answers to your question start with something along the lines of...

"Don't use repeating fields"

[LiveOak]

Kind of like when you ask what 2 + 2 is, you're bound to get a lot of 4's.

If you have defined the repeating fields for wholesale price and retail price to be lookups based upon ProductID, it should work. I have a couple of old files which use repeating fields in the manner and work OK. If you are using the "extend" function, something is a calculation. Since this can all be done with lookups, where does the calculation come in?

-bd