P
pietlinden
I have a main form (protocol/study) and then a subform for enrollment
(patient on a study). Works great.
Okay, before I confuse everyone...
I have two sets of enrollment relationships...
tblpatients---(1,M)---tblpatientsprotocols---(M,1)----tblprotocols (in
SQL Server)
Patient---(1,M)---Enrollment---(M,1)---Protocol (in Access)
For the database I am working on, I am only interested in a very small
subset of the patients/enrollments/protocols in SQL Server, so I made
the Protocol control on my form a combobox that uses tblprotocols as
it's rowsource.
I want to do something like this:
1. user chooses a protocol from the complete list of protocols (the
list is in a table in SQL Server that I can query).
2. if the protocol does not exist in the local protocols table, add it
to Protocol, then allow the user to fill in the rest of the form or
create child records (enrollments).
If the protocol exists already in the local Protocol table, just go to
that record in the main form (parent-most form) and then set focus to
the first control in the "Enrollment" subform.
What's the best way to do this? Use Seek on the Protocol form's
recordset clone? I'm trying to make this as foolproof as possible,
because the person who will be using this database is not super
computer literate...
Thanks!
Pieter
(patient on a study). Works great.
Okay, before I confuse everyone...
I have two sets of enrollment relationships...
tblpatients---(1,M)---tblpatientsprotocols---(M,1)----tblprotocols (in
SQL Server)
Patient---(1,M)---Enrollment---(M,1)---Protocol (in Access)
For the database I am working on, I am only interested in a very small
subset of the patients/enrollments/protocols in SQL Server, so I made
the Protocol control on my form a combobox that uses tblprotocols as
it's rowsource.
I want to do something like this:
1. user chooses a protocol from the complete list of protocols (the
list is in a table in SQL Server that I can query).
2. if the protocol does not exist in the local protocols table, add it
to Protocol, then allow the user to fill in the rest of the form or
create child records (enrollments).
If the protocol exists already in the local Protocol table, just go to
that record in the main form (parent-most form) and then set focus to
the first control in the "Enrollment" subform.
What's the best way to do this? Use Seek on the Protocol form's
recordset clone? I'm trying to make this as foolproof as possible,
because the person who will be using this database is not super
computer literate...
Thanks!
Pieter