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 ?
me if this is possible ?
|
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... |