Jump to content

Defining unique fields


Beno
 Share

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

Recommended Posts

Hello.

I'm defining a new file and I would like to have two fiels as identifiers (unique fields) for that file. How is that possible. I don't want them to be unique separetely, but that their association is unique. I need your help. I'm thinking about some calculated verification, bit it really looks like a "trick". Is there some other ways ?

Thanks.

Link to comment
Share on other sites

  • Newbies

So, if I understand it correctly, you'd like for the relationship between two fields to be unique?

I can think of one way to do this, assume fields A and B are the unique fields, and the result of A+B is what you'd like to keep unique.

Make a third field C (A regular number field in this case) with auto-enter data of a calculation A+B. Then make that field unique in the verification tab.

Hope this helps.

Link to comment
Share on other sites

This topic is 6546 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
 Share

×
×
  • Create New...

Important Information

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