Forum Discussion

MeganLowmaster's avatar
MeganLowmaster
Qrew Member
5 years ago

Re: duplicate names

If I put in a name to make another profile and the name is already in the database I get this error message. Fields which are marked unique must contain unique values for all the records. You have entered a duplicate value for the unique field "Name" Please check your data and try again.
(The individuals of interest was not saved)
I was not sure how to go around this or what I needed to do to put the same name in when it is a totally different person.  I basically want to create another profile for same name but different person without altering or adding to the name itself.

------------------------------
Megan Lowmaster
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    There is a solution.

    Is the Key field of your table the [Record ID#] field or the [Name] field?

    If it is the name field, then that field has been marked as being unique.  Is the Name field a data en try field or is it a formula field which concatenates the first and last names together into a single Name field?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MeganLowmaster's avatar
      MeganLowmaster
      Qrew Member
      5 years ago
      It is a name for the record that must be why it is unique!  So how do I go about adding the same name to another complete record then?

      ------------------------------
      Megan Lowmaster
      ------------------------------