repeating fields into a related field

[falkaholic]

I am making a invoice database that has repeating filelds for itemid, quantity, price etc.

One of the features i want to add is to be able to subtract the quantity from the number in stock; which is in another database.

I have a script that should work. but filemaker doesn't allow coping it so i can't show what i have.

but the basic idea is that it loops through the every repetiton with getRepettion and then does:

SetField["items::quantityOnHand", extend(items::quantityOnhand) - GetRepetition("quantity", extend(loopVar)]

that above line just takes all the quantitys off the first Item.

How can i get around this?

Thanks

[Kurt Knippel]

NEVER EVER USE REPEATING FIELDS.

Filemaker only performs operations on the first repeat.

Your best bet is to move to a fully relational system, which basically just means that you need a lineitems file to replace your repeating fields.

[falkaholic]

ya. thanks.

just figured that out when i did a search of old topics.

I did have that was in the first draft. but i couldn't figure a way to total the line items in the master database. but i realized tis as easy as Sum(lineitems: rice)

back to the drawing board.