Application Number ?

[Alex Anderson]

Everyone,

I'm creating a form that needs an indentification number presented on it and
I tend to use the autonumbering of one of the primary keys of my Slip_ID
column. It will always be unique but I need to somehow get this on the form
so they know what slip number they have for reference. My question is, if
I'm using SQL 2005, will that number be presented before I submit the data?

Thank you
Alex Anderson

 

[Paresh]

Everyone,

I'm creating a form that needs an indentification number presented on it and
I tend to use the autonumbering of one of the primary keys of my Slip_ID
column.  It will always be unique but I need to somehow get this on theform
so they know what slip number they have for reference.  My question is,if
I'm using SQL 2005, will that number be presented before I submit the data?

Thank you
Alex Anderson

Hi Alex,

You can show database data on the form without any issues.
All you need to do is to have a dataconnection.

Do let me know, in case you need any further information.

Thanks,
Paresh

 

[Alex Anderson]

Paresh,

I created another data connection to retrieve information and I inserted the
field I want to display but the number it shows is the very first record in
my database. How do I tell the form, rather that control to fetch the next
number in line?

Thank you
Alex Anderson

 

[Paresh]

Paresh,

I created another data connection to retrieve information and I inserted the
field I want to display but the number it shows is the very first record in
my database.  How do I tell the form, rather that control to fetch the next
number in line?

Thank you
Alex Anderson









- Show quoted text -

I guess for this, you will need to modify the SQL query that you might
be using in the data connection method.

Thanks,
Paresh

 

[Clay Fox]

Often you want to use the Max () function. To get the largest number in the
returned set and then +1 to get the next ID number, if they are sequential.