I have some auto generate fields in the database. I want that when i open ...

Posted by Sp under Regular Expressions on 8/14/2010 | Points: 10 | Views : 2063 | Status : [Member] | Replies : 4
I have some auto generate fields in the database. I want that when i open the form initially to enter details w.r.t patient. The form should appear with the value of auto generated patient Id. How to to this???

Also,
The form has a column named .Admission ID, i have the reference of this field in both the master table and tbladmissions,. In tbladmission the field is auto generate. i want to show the value of this field also on the patient registeration Page!!!

I.e. In patient Registeration page i want to show
patient Id-->auto generate via patients table
Admission ID-->auto generate via tbladmissions

Plzz guide!!




Responses

Posted by: Raja on: 8/14/2010 [Member] Starter | Points: 25

Up
0
Down
Generate a blank record in the table and get it to your form. When the user will submit the data, you will have to update the same record with the patient data.

Thanks

Regards,
Raja, USA

Sp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sp on: 8/14/2010 [Member] Starter

Up
0
Down
I have set patient id as auto generate in Sql server by setting identity field.
I want the value generated to show on the form when it is initially opened...

Sp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raja on: 8/14/2010 [Member] Starter

Up
0
Down
You need to do the same thing that I said in my earlier response.

Thanks

Regards,
Raja, USA

Sp, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Raja on: 8/14/2010 [Member] Starter | Points: 25

Up
0
Down
Just give a try and let us know if this works for you.

Thanks

Regards,
Raja, USA

Sp, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response