Home » Developer & Programmer » Forms » find duplicates before commiting the records
find duplicates before commiting the records [message #78548] |
Fri, 01 March 2002 06:41  |
neel
Messages: 12 Registered: November 2001
|
Junior Member |
|
|
I have a form based on the table which has a Primary key with a combination of (item_num, cust_num). The form is showing the cust_num and all the items for that customer. I have an add button on the form by which we can add more items to that customer, but now while adding it is not keeping track of the duplicate items entered. When i save the form, it gives an error saying 'Unable to Insert record'.
If the user has entered 20-25 items altogether and then gets the error, it will be difficult for him to find the duplicates manually. Is there any way i can check for the duplicates before saving. I also want the user to see the duplicate item numbers so they can do the necessary corrections.
Thanks in advance. Any help will be appreciated.
|
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 01:21:22 CDT 2025
|