S
stacie
Hello all.
Here's the deal:
I have to import several spreadsheets into one table with historical data.
From the tables, I want to make a form so that the end user will choose which
form to complete to populate the one table. For example, in the form I may
have a line with a patient's name, admit date, discharge date, charges,
future appoint, etc. When the patient is first entered into the data base, I
don't know when the discharge date so I was thinking this would be considered
another form? Also, charges are not know at the time, so this would be
another form. The end goal is to have one table with all information so that
I can query the information. Can anyone tell me where to start?
Here's the deal:
I have to import several spreadsheets into one table with historical data.
From the tables, I want to make a form so that the end user will choose which
form to complete to populate the one table. For example, in the form I may
have a line with a patient's name, admit date, discharge date, charges,
future appoint, etc. When the patient is first entered into the data base, I
don't know when the discharge date so I was thinking this would be considered
another form? Also, charges are not know at the time, so this would be
another form. The end goal is to have one table with all information so that
I can query the information. Can anyone tell me where to start?