automatic record propagation

T

Ted

[with apologies in the event the first instance of this i posted much earlier
this morning shows up as well as this one...]

first a look at the software side: i'm using a2k and have a database where
there are two forms, let's call them parent and child which are related via
the patient_number and cycle_number of the tables underlying each. as you
might expect, child is nested w/in parent.

i have some user(s) who, being the slackers they are, would prefer not to
have to re-enter a patient's information for a certain drug_name that is
recorded for a patient_number and cycle_number when the facts surrounding the
patient's experience are the same and the cycle_number has incremented by +
1, each time it is reviewed provided the user has clicked a button indicating
problem_continuing for a given patient_number.

so for patient_number 123 and cycle_number 1 and for drug XYZ, if the user
checked the problem_continuing box, the next time the user went to the main
form and filled in the information for this patient_number for his
cycle_number 2, the subform would be prefilled with the same information as
had been entered for cycle_number = 1 with the exception that the
problem_continuing control would be set to 0/"No".

hope this makes sense to someone?

thanks for any bandwidth.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top