How Can I introduce auto number in a form field in InfoPath 2003

[Ricardo Villalonga]

I just want My InfoPath to return a number Automatically when I open a Form.
What I have to do? Thanks

 

[Ricardo Villalonga]

Hi, I try it and didn't work, what I want is just in my DataBase a have a
field (Order Nmber) and this Data Base is going to be used by different
people at the same time, So I need to created a different Order Number for
each form that they Submited, it will work as a Confirmation number for a
customer. You in Access Data Base it's to easy to create this Auto Number
field from your Table, But in InfoPath 2003 it's a little hard to get this
work.

 

[Clay Fox]

Hi Ricardo.

There are multiple ways to do this and it is easier with SQL express than
Access, I think anyway.

Typically you need to query the table, get the highest number (use the Max
function) and then do a +1 or plus random. The challenge though with multiple
users is that they each need to get a unique number even if they open the
form and take a long time to submit it again.

I would recommend you look at the Database Accelerator. If you are creating
an enterprise solution from a backend database then it is the best way to go.
It gives you many web services which allow you to query and submit to
multiple tables and databases. You can also then have SQL or SQL Express do
the autoincrement, this is the best way to eliminate the possibility of
duplicates.
http://www.qdabra.com

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[sboyd]

I just want My InfoPath to return a number Automatically when I open a Form.
What I have to do? Thanks

This worked for me. I had a repeating table that I wanted to advance 1
for each row (the leg_No). This was in a repeating table. I set the
default value to the formula:

count(../preceding-sibling::d:Flight_Leg/@Leg_No) + 1

Flight_Leg was a child node of Flight_Log