In datasheet view of forms, duplicate records

[Raveen1609]

Hi, I have a bsic knowledge in Access. I am creating a small database for Doctor appointment. I have a form viewing in datasheet view, with field ApptDate and ApptTime (Drop down list of times). and a doctorName field and PatientName field



Now I want to avoid duplicating the all the 3 values. For the same date, already selected time and doctor name should not be accepted. Either a popup message or the previously selected time value shouldnt be there in the drop down list. Also dont want the patientName not repeat for the same date.

Kindly give advise, on how to overome this problem.

Thanks

[ranman256]

key the table to prevent duplicates, and date/time should be 1 single field (don't make 2 fields ,BUT you can show 2 boxes ; 1 for date , 1 for time yet 1 field.) :

ApptDate*
PatientID*

[Gicu]

In addition to ranman's suggestions you need to lookup Cascading combo-boxes in this forum and in general on the web, there are many examples around. Basically you need to edit the row sources of the doctor and patient to eliminate those already booked for that date and time (by using a left outer join - see example by creating an "unmatched" query using the query wizard.
Cheers,