Pedro Posted July 4, 2001 Share Posted July 4, 2001 Hello Folks, In my database the primary key is a calculation field that is a fusion of 3 other fields. Because it's the primary key it must be unique, how can i solve it? Thanks. Link to comment Share on other sites More sharing options...
LiveOak Posted July 5, 2001 Share Posted July 5, 2001 Sounds like hitting a screw with a hammer, but here goes. You can enter all three field entries into global field and have a "Enter" button. This button will run a script to find any exact match of the concatenation of the three fields and return an error to the user if a match is found. If no match is found, the script would copy the global field to the real fields. -bd Link to comment Share on other sites More sharing options...
LiveOak Posted July 5, 2001 Share Posted July 5, 2001 My best response is don't use this calculation as a key. Sounds like you have a logical problem with how your are setting things up if three selections are made by the user BUT the key still has to be unique. -bd Link to comment Share on other sites More sharing options...
Pedro Posted July 5, 2001 Author Share Posted July 5, 2001 But , here in my company the users are working with it for a long time and I think if I modify the way that they are working it will make them confused. I need to make this field unique.......... help me please.... Thanks Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8353 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