Hi All,
I wrote this board several months ago that my wife and I volunteered to do an Access database for a free clinic in the area. I did the analysis and my wife worked with access to create the database, queries, forms, etc ... I am pleased, surprised and proud to report that my wife did a great job with only minimal access training and without seeking any outside help as I had expected - until now :-) . We will be demonstrating the database to the clinic Friday. She does have 1 question that is probably fairly simple for you experts.
Question:
When the form is brought up to "add a new patient", she would like to automatically fill-in the "Patient I.D." into the the form. It should be the last (highest) Patient I.D. in the database plus 1. The Patient I.D. is the primary key in the Patient_Table but it is not computer generated. Can someone please give her some help regarding how to do this including the proper syntax for any query/macro/condition that is necessary to use to accomplish this. Any help will be much appreciated.
Thanks,
Tom
Tidak ada komentar:
Posting Komentar