Unique Field (RecID)

[Clayton King]

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]

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]

Sorry. How do I prevent entering the same product ID twice? How do I tell Filemaker that ProductID must be unique?

[comment]

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 1 hour ago by comment