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

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.

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