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