AnsweredAssumed Answered

setting up relationship to show a subset of records

Question asked by denno on May 10, 2011
Latest reply on May 10, 2011 by philmodjunk

Title

setting up relationship to show a subset of records

Post

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-

Outcomes