Can you prevent duplication of Record Names?

[Greg Spink]

I wondering the best way to prevent duplication of record names.

Rough Over view

I have these forms

Products

Formulations  (many formulations records can link to many Products records)

Ingredients  (many ingredients can link to many Formulations)

 

Each record has a name,  How do I prevent duplication?  Can you have the name field as you name it check no other record on the form contains the same record name?

 

IS this built in or does this need to be scripted?

any help would be appreciated.

 

 

• This topic was modified 10 months, 1 week ago by Greg Spink.

[Brendan]

Hi Greg,

There’s no direct built-in function for this, but if you enable the Show Auto-Complete function on your field, then Tap Forms will display a menu of values previously entered into that field for all records. Then you can see if you’ve already used a name since it will appear in the menu.

Thanks,

Brendan

[Greg Spink]

Thats Brilliant,  Thank you Brendan.  That will work.

[Author]

Posts