setting up relationship to show a subset of records
I am setting up a database for patients admitted to the hospital with pneumonia. The data are imported from an Excel file. The 1st table is PATIENTS. One of the fields is hospital location; one of the values for that field is ICU. I would like to analyze the subset of patients admitted to the ICU. I created a 2nd table named ICU. This table has a location field that has an = relationship to the location in PATIENTS.
I'm stuck on creating records in ICU. If there are 20 ICU admissions in PATIENTS, I need to create 20 records in ICU, correct? I'm not sure how to accomplish this--do I need to run a script after import that creates the record based on a calc?
Thanks for any help-