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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jhon S. - 24 Mar 2006 14:17 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 24 Mar 2006 15:54 GMT

Did you already try the instructions in the following tutorial using count()
instead of position()?
http://www.infopathdev.com/howto/tutorials/default.aspx?i=d663d7df90e94e65abb026
32966e8127
--
S.Y.M. Wong-A-Ton

> 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
[quoted text clipped - 4 lines]
> Thanks
> Jhon

Reply to this Message

Jhon S. - 28 Mar 2006 02:37 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 28 Mar 2006 07:46 GMT

What are the current challenges you are experiencing?
---
S.Y.M. Wong-A-Ton

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

Reply to this Message

Jhon S. - 29 Mar 2006 23:56 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 31 Mar 2006 11:34 GMT

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).
---
S.Y.M. Wong-A-Ton

> I tried..using the tutorial you give me ...!
> And it work fine for XML created gorups and fields but it doesnt work for
[quoted text clipped - 7 lines]
> Thanks
> Jhon

Reply to this Message