I haven't messed with Access in 10 years.
I now realize that a Database is the best way to go.
I have gone beyond the capabilities of Excel.
The task:
A patient tracking Database.
I need to track the LDL Cholesterol results for patients.
My Spreadsheet now has the following fields:
Name - MRN - Date of LDL - LDL Result - Contact Type - Contact Date - Notes - Retest Date
The MRN is a unique Medical Record Number
The Retest Date is either 6 months (182 Days) from LDL Date or 50 Days.
(If LDL Result < 100, Retest Date = Date of LDL + 182 Days, ELSE Retest Date = Date of Last LDL + 50 Days)
I invision Splitting the Spreadsheet into the following Tables:
1. Patients:
Field 1: Name
Field 2: MRN *
2. Results:
Field 1: Result_ID *
Field 2: MRN
Field 3: Result_Date
Field 4: LDL_Result
3. Contacts:
Field 1: Contact_ID *
Field 2: Contact_Type
Field 3: Contact_Date
Field 4: Notes
4. Contact_Types:
Field 1: Contact_Type_ID *
Field 2: Contact_Type (Phone, E-Mail, Message, Appointment, Letter) - For a list Box
* Denotes Primary Key
Can any of you Guru's assist me in setting this up, if in fact My structure is sound?
Or can you make suggestions as to the proper structure.
I would like to see a list of patients with all data on one line.
I would only need the most recent LDL Date and Value to show.
I would like the Contact_Type field to be a drop down box to select fro.m.
I would also like to be able to edit the Contact_Date, and notes fields