M
mhmaid
I have the following fields atientid,TravelDate,ReturnDate. the Patientid
is an autonumber , the other two are date/time .For most patients , there
will be more than one record (one visit). what i want is , when the user
enters the traveldate for a new visit of a patient, to look up the table
(PatientsMaintable) , and see the previous visit whether return date has been
entered or not , if not to just prompt the user and give him the patient id.
Any one knows how this can be done?
is an autonumber , the other two are date/time .For most patients , there
will be more than one record (one visit). what i want is , when the user
enters the traveldate for a new visit of a patient, to look up the table
(PatientsMaintable) , and see the previous visit whether return date has been
entered or not , if not to just prompt the user and give him the patient id.
Any one knows how this can be done?