Needing help with the below mentioned

[FCollazo]

I'm creating an access 2007 database and want to store information on patients. I've created a patients table and want to track vital signs per patient on a single table or the like. I'm a novice and don't know if this is something that can be done on access. Please HELP.

[June7]

Certainly can be done.

Need a table of patient info and a table of vital readings. How many signs? Table setup could be:

tblPatientVitals
RecordID (primary key)
PatientID (foreign key)
VitalSign (Systolic, Diastolic, Pulse, etc)
Reading (number field)
DateRead

Or
tblPatientVitals
RecordID
PatientID
DateRead
Systolic
Diastolic
Pulse
other fields as desired.

[FCollazo]

I don't think I'm asking for what I need. I want to be able to track a single patients vitals on a single table. Everytime the same patient comes in, we want to be able to track his vitals on that table or form and would like to do the same for each patient. One subtable from the main table to track vitals for each of the patients.

I want to be able to click on a record of the main table, have it linked to the vitals table, have that table come up and be able to place all of that patients vitals on the vitals table and have a history of his vitals on this subtable.

[June7]

Should not be a table for each patient. One table for all vitals. Use queries to filter to the desired records. Use forms to interact with tables and queries for data edit/display. Reports to output data.