View Full Version : Duplicates


Blair Greene
11-22-2001, 05:24 PM
I'm under a deadline, trying to see if it's possible to prevent duplicates within a combo box for data entry... Can anyone tell
me if this is possible ?

saintsman
11-23-2001, 12:10 AM
I don't understand why you would not want any duplicates. Surely the combo box is there to allow specific data to be added.

Blair Greene
11-23-2001, 05:34 AM
I want to avoid duplicates, especially in
the combo box, the system is used for scanning in bar codes for inventory and I need to try a prevent duplication entries, I
am under a deadline on this one...

Pat Hartman
11-23-2001, 11:11 AM
To prevent duplicates from being added to a table, create a unique index on the field or make it the table's primary key.

I don't understand the reference to the combobox. If the combobox is being used to select the barcode, the rowsource of the combo should be based on a table that contains a unique list of barcodes.

Blair Greene
11-23-2001, 03:04 PM
Thanks...
The reason duplicates cant be permitted on that db is because it's used for a cable companies inventory... they scan
in hundreds of items per week via "bar code"
with your help I have reloved this problem
by building a relationship to a table that
had the necessary permissions set...