Can you prevent duplication of Record Names?

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Can you prevent duplication of Record Names?

Viewing 2 reply threads
  • Author
    Posts
  • June 26, 2023 at 4:53 AM #49636

    Greg Spink
    Participant

    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 1 year, 5 months ago by Greg Spink.
    June 26, 2023 at 12:03 PM #49638

    Brendan
    Keymaster

    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

    June 27, 2023 at 4:05 AM #49641

    Greg Spink
    Participant

    Thats Brilliant,  Thank you Brendan.  That will work.

  • Author
    Posts
Viewing 2 reply threads

You must be logged in to reply to this topic.