SetField with a Repeating Field

[KoenBous]

I'm creating an invoice, one delivery = one record. So more than one product in each record is normal. I have 5 repeating fields. If 4 of these fields match with 4 fields of a record in my pricelist, the 5th field must contain the price from the pricelist.
The problem: I can find the price and put it in my invoice, only it is always on the top of the field and not on the corresponding line.
The getrepetition function is very useful for reading, but how can I write on a specific line of a repeating field?

Thanks for any comments/help

Koen

 

[marty1452]

Printing is tricky sometimes in FM. Look in the layout mode under FORMAT on the menu, slide printing. The field could be sliding up to eliminate the unused spaces.

Another option if possible, if your code knows the value is in the 5th field, could you add 4 paragragh symbols then the value. This would enter carrage return 4 times then the value.

If this does not work, you can email the file to me and I'll look at it for you. mlisonbee@charter.net

I hope this helps.

Marty

 

[KoenBous]

Thanks for the fast response. I tried several things and at last I added another field in both files with a 'code' = field1 & field2 & field3 & field4. With this field I made a relationship and my pricefield is now a lookup value with the codefield. It works and I'm happy

Ciao

Koen