The setup:
I have developed an anesthesia assessment form attached to our clinical
database. This form's data model has two tables in it. There are times
when
these patients are repeat patients. I would like to be able to give the
user
easy access to the previous assessments and even copy some of the data
from
a previous encounter that the user will choose.
I don't want the current record to show up on the form showing the
previous
records
The question:
Is it better to use setgenfilter and just filter for the patients medical
record number OR have the form run a query and copy all the previous
records to a new set of tables and have them view the records in a new
form
and do what they need to do?
I think the first one is the most elegant but I don't see a way to do
setgenfilter and NOT have the current record also viewed.
Thanks,
Craig Futterman
