K
Karen
I am trying to create a form for my data, but each time I set it up something
different doesn't quite work, so I suspect there is something wrong with my
approach. I would be very grateful if someone could suggest an appropriate
set up for the following data.
I have three tables,
1. Patient Demographic Data
Hospital Number (primary key)
Surname
Name
etc
2. Event
Case Number (primary key)
Hospital Number
Date
Procedure
3. Results
Laboratory Number (primary key)
Case Number
testtype1
testtype2
etc
I have 1-many relationships between Hospital number (Patient Demographic
Data ->Event) and Case Number (Event->results).
I have a query linking all of the above data (Full Database Query).
I would like the form to be based on Patient Demographic Data and Event,
with Results being the subform.
Up till now the problems have included being unable to enter any data in the
subform (ie "can't have a null value on primary key" whilst actually tring to
enter the data in question), errors in connecting the tables (jet database
engine errors) or being unable to introduce a new patient to the database.
Thanks in advance
Karen
different doesn't quite work, so I suspect there is something wrong with my
approach. I would be very grateful if someone could suggest an appropriate
set up for the following data.
I have three tables,
1. Patient Demographic Data
Hospital Number (primary key)
Surname
Name
etc
2. Event
Case Number (primary key)
Hospital Number
Date
Procedure
3. Results
Laboratory Number (primary key)
Case Number
testtype1
testtype2
etc
I have 1-many relationships between Hospital number (Patient Demographic
Data ->Event) and Case Number (Event->results).
I have a query linking all of the above data (Full Database Query).
I would like the form to be based on Patient Demographic Data and Event,
with Results being the subform.
Up till now the problems have included being unable to enter any data in the
subform (ie "can't have a null value on primary key" whilst actually tring to
enter the data in question), errors in connecting the tables (jet database
engine errors) or being unable to introduce a new patient to the database.
Thanks in advance
Karen