I want to know how to enter data in repeating fields using value lists from a related file. In detail - I have two databases - one for invoices with repeated fields for Product Code, Batch No, Rate, Quantity etc. and another one as my Product Master with fields for Product Code, Batch No, Rate etc. and containing multiple records for Product Codes with different Batch Nos.

Now in the invoice file I have a value list for Product Code from the product file. When I select a particular product code the other fields (Batch No, Rate) automatically get filled up based on the lookup. I want that the repitition of the Batch No field should show only the batch Nos for the Product Code which I choose. At present I am getting either all the values or the values associated with the first product code.

Hi,

Take a look here or here for samplers that do what you're after, but that should also discourage you from doing it.

The second link shows both ways so that you can choose the appropriate way.

HTH

Filemaker went relational about 10 years ago. You should ditch the repeating fields and go with a proper relational design. That's what UGO is telling you, but he isn't being clear enough.

Right !

Should have be

The second link shows both ways so that you can move to the appropriate way.

instead of

The second link shows both ways so that you can choose the appropriate way.

There's actually no choice left.

Thanks Bruce