Index (no duplicates)

[Guest]

I have a database that keeps track of prescriptions (by patient) and the
doctor that writes each prescription. The relevant tables are Patient_t,
Scripts_t, Doctor_t and Meds_t. The Doctor_t is related to the Scripts_t in
a one to many relationship using the DoctorID. Within Doctor_t there is a
primary key (DoctorID). In addition there is the field DocName which I want
to have as Indexed (no duplicates) but so far am unable to accomplish – help.

I have a combo-box (created using the Wizard to Lookup record from
Table/Query, option) where I enter the DocName (Row Source is the
Doctor_q.DocName) or select an existing record (DocName). If I select an
existing DocName a new record (DoctorID ) is created and I end-up with
duplicates records having the same DocName. Suggestions? Thank you.

 

[Ken Snell [MVP]]

Sounds as if the form's Data Entry property is set to Yes. Change it to No.