Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8506 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted

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.

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.