Clayton King Posted April 15 Posted April 15 Total noob question and I'm embarassed I don't already know the answer. I have a table of products and want the product number to ensure the record is unique. I'd like to use this product ID as the unique record identifier, rather than the UUID. How is this a complished?
comment Posted April 15 Posted April 15 I don't understand your question. If the product number is unique and immutable then you can use it as the primary key instead of an auto-entered UUID / serial number.
Clayton King Posted April 15 Author Posted April 15 Sorry. How do I prevent entering the same product ID twice? How do I tell Filemaker that ProductID must be unique?
comment Posted April 16 Posted April 16 (edited) You can validate the field as Unique. But I still don't understand where you're coming from. Or rather, where are these ProductIDs supposed to come from. If they are coming from a third party and you cannot trust them to be unique, then don't use them. Otherwise you will run into a problem when validation kicks in and tells you that the value already exists - and then what is the user supposed to do? Edited April 16 by comment
Recommended Posts
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