Repeating field relationships

[FMJoey]

I have two db files, one for Invoices, one for Products. In the invoice file

I have a repeating field (Item No's) formatted as a pop-up list of related values from the product db field "Item No's". In the Product db I have 3 fields for 3 different price breaks for each record. I am trying to make a calculation in the Invoice file that will determine the correct price break based on the qty entered for each product listed in the repetition. Any calculation I make only works for the first line in the repetition, every line below will get the same pricing data from the first repetitions record even if it is a different record. I've tried using the extend function with no success. Am I wasting my time trying to make this work? Is there a better solution? Please help!!

Version: v5.x

[bPlatform: Windows 2000

[BobWeaver]

That is one of the many problems with repeating fields. You should dump them and use a relational design instead with a portal to a line items file. Each invoice item is then a separate record in the related file. Life will be much easier.

[FMJoey]

Ahhh yes, I see the light! Many thanks!

Looks like its back to the drawing board!