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

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

"Don't use repeating fields"

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