AnsweredAssumed Answered

Question about GetNthRecord

Question asked by bartprins on Jan 3, 2014
Latest reply on Jan 4, 2014 by Oliver_Reid

Hi there and happy new year to all,

 

I've got two tables one for instance is Customers and the second table is Products where they have a relationship one customer to many products. (The fields and names are just an example)

 

I have made a layout with Customerdetails and Products in a portal.

In the table Products there is a field [productname] and a field [VAR] which has a value of "000000000002" for each record (i get these from a third party) which i want to edit with a plus one for each product for that customer

 

So for instance:

 

Customer1

Apples000000000002

Bananas000000000003

Customer2

Pears000000000002

Bananas000000000003

Apples000000000004

 

etc..etc..

 

I think i have to use a loop with GetNthRecord, where i say something like: GetNthrecord edit [serial + 1] or something in that order but know where to start

 

Thanks for reading

 

Bart Prins

Outcomes