adding new data to a table where data already exists.

[Andre C]

Sorry about the title, could not decide on a better one.

I need some guidance on the best way to solve a problem. database has
a table which lists patients and their details. One of these details
is a data of admission and a date od discharge. Problem is patients
can potentially be readmitted at a later date. I need a way of
recording all the different admission and discharge dates.

At present I am not saving the data. The inputers merely overwrite the
old data. This is not satisfactory.

First I thought of an audit trail but feel this may be overkill. Then
I thought I would remove admission and discharge date fields to a new
table which could store multiple instances of the clients with the
dates. Question is via the patient input form how can I add new dates
to this table. The form just has test bnoxes for admissionand
discharge date so the inputer would still just overwrite the old data.
I need to somehow transfer the old data to the new table.

Any help appreciated.

Andre C

 

[Jeff]

Hi Andy,

If one patient may have many differnt admittance and discharge dates,
then it would be best to have these in a separate table with the patient
unique ID as a link.

Then you could connect this information via a subform where subform
Patient ID = mainform patientID

Classify by date ascending order to have the most recent date at top.

This way, you don't have to be transfering and overwriting data, just
add a new record to or update the subform whenever necessary.

Hope this helps,

Jeff C