I have created a quotation dbase (F1) in which I have three fields, Item, Product & Price, with repeats. I have another file (F2) with the same fields which are related by "Item".

The F1 has a dropdown list for Item, from F2 "Items". Product is "looked up" from F2, conditional on "Item" in F1.

This works for the first line of the repeating fields but subsequent lines are controlled by "item" in line one.

Is there a way to force a lookup based on Item in each line?

Thanks, Bruce

Hi, wascal.

Now i tried and lookups all repetitions.

Desktop.zip

Tks AAA. I agree with that.

In the lookup file, Item (I should have called it "group"), can have multiple products. ie, "a" would have a number of products (records) as would "x".

Now in F2, make "item" a repeating field and format it for a dropdown list from "Item" in lookup. Make "Product" a dropdown list from "product" in lookup (related to "Item" in F2).

I find that for the first line, all is ok but the second, even though I select a different item, the product dropdown still gives me a list based on the first line.

Any clues, Tks, bruce