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 : 3860 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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!!

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

Latest Posts