' So busy today but just for you to start, you need the following main tables: ' tblPatient - will handle the patient information ' tblVisits - will handle visits information & history (must be linked to tblPatient (Patient ID) ' tblDoctors - will handle the Doctor's dropdown menu
' Never use AutoNumber for your PatientID, if you want an auto serial#, you can use the Dmax function ' or just go to http://www.rogersaccesslibrary.com/ and look for Autonumber.. ' HTH, ' George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of katlaw1 Sent: Monday, October 15, 2007 8:21 AM To: [email protected] Subject: [ms_access] Table setup help-Please assist tonight if possible please I am trying to set up some tables in Acess to do the following: The scenario is this: A person visits the hospital. On the first visit they are assigned a medical record number that is their unique identifier. (sort of like a social security number) Each time after that they come in, they get a visit number so they can have many visit numbers depending on how much they come in. Also the doctors can order one, many or not test done so the order field could repeat. I have the folling other fields that i will put in the table patient name birthdate date of the first visit visit date (date of a particular visit) doctor (the doc that saw them at the visit) order description (what they had done ex-blood work) [Non-text portions of this message have been removed]
