Duplicate subform entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my main client info form, I have a subform to enter the preferred schedule of my clients, The link is the CustomerID field.

I'm not sure, but I'm assuming that the roller mouse is rearing it's ugly head here. Every once in a while I come across in reports where a client has a duplicate schedule. I look in the table and sure enough there are two ScheduleIDs. I've been just deleting the extra schedule here and there. Is there a way to prevent duplicates from being added to the Schedule

By the way, the query on my report from the combo box issue is working great!!! Thanks so much
 
Go into Design View for the Schedule table and set up a
Unique Index for the required column(s).

Hope This Helps
Gerald Stanley MCSD
-----Original Message-----
On my main client info form, I have a subform to enter the
Click to expand...
preferred schedule of my clients, The link is the
CustomerID field.
I'm not sure, but I'm assuming that the roller mouse is
Click to expand...
rearing it's ugly head here. Every once in a while I come
across in reports where a client has a duplicate schedule.
I look in the table and sure enough there are two
ScheduleIDs. I've been just deleting the extra schedule
here and there. Is there a way to prevent duplicates from
being added to the Schedule?
By the way, the query on my report from the combo box
Click to expand...
issue is working great!!! Thanks so much
 
Index - Yes (No duplicates)

I figure with a name like Gerald (my son's name) and the same last initial you wouldn't steer me wrong! ;)
 
Back
Top