Newbies bonslo Posted July 25, 2001 Newbies Posted July 25, 2001 I keep a simple database of supplies ordered by our laboratory. Each order is given a unique id number. This field is defined as 'Strict data type, numeric only' and 'unique'. The problem is, when a user duplicates a record, the id number is duplicated. I need to allow duplicating records but prevent the contents of the 'id number' field from duplicating. Many Thanks Brett Onslow
slbr549 Posted July 25, 2001 Posted July 25, 2001 Do you have the id number field set as a serial number field that automatically increments by 1 each time a new record is created? This will avoid the duplicate id number problem you are having.
Kurt Knippel Posted July 26, 2001 Posted July 26, 2001 quote: Originally posted by Brett Onslow: I keep a simple database of supplies ordered by our laboratory. Each order is given a unique id number. This field is defined as 'Strict data type, numeric only' and 'unique'. The problem is, when a user duplicates a record, the id number is duplicated. I need to allow duplicating records but prevent the contents of the 'id number' field from duplicating. While this does not specifically address your issue, check out my new FAQ on the subject of IDs for some hints on how to deal with these kinds of issues. http://www.fmforums.com/ubb/cgi-bin/ultimatebb.cgi?ubb=get_topic&f=8&t=000018
Recommended Posts
This topic is 8506 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now