How to create multiple instances of a form that will retain some.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Problem:

I am creating a form to collect data on transfusions.
Each unit of blood is a separete entry into the data base.
Some Individuals receive multiple units of blood.

Can I create a form that will allow me to retain the patient demographics
and enter information on a second unit of blood in a new record?
 
Kjacob,
This is exactly what a realational database is for... a One to Many
realtionship.
Your patient information should be in one table, and include some unique
identifying key field.
Your units of blood should be in another table, and be "linked" to the
patient table by the value of that same key field.
Your main form should be based on the patient info, and a subform based
on blood units. That way, ONE patient can have MANY units of blood.
hth
Al Camp
 
Back
Top