Urgent: how can i get numbered items in a Repeating table

J

Jhon S.

I have a repeating table bounded to an Acess BD;And I want to automatically
fill in with numbers the items field, in the order they are entered.The name
of the field is Item which is contained in a secondary source
(Equiment_detail) i try to use the position() function but it just work for
the first field and the next items show the same numer 1.
please i will much apreciate your help
Thanks
Jhon
 
J

Jhon S.

thanks SYM
but i still having probles; can you please use a more detail example......!
I´ll apreciated
Jhon
 
J

Jhon S.

I tried..using the tutorial you give me ...!
And it work fine for XML created gorups and fields but it doesnt work for
the secundary data source which have the Item field;
I Try to figured out and found a chek box that have disabled the repiting
property for the Sec Source Item field
So I tried to convert the text box from the Item Field to a Expresion box
but although i get the auto generating numbers for the Item field it just
stores "0" ceros in the DB but not the number show in the form
Please i will much apreciate your help
Thanks
Jhon
 
S

S.Y.M. Wong-A-Ton

Sounds like your scenario is more complicated than originally described. How
are you updating the secondary data source? Through code? If so, you need to
either retrieve the last ID entered in the DB table and add a 1 and then do
the insert, or use a stored procedure to insert the record (if you are using
SQL Server).
 
Top