duplicate names
I am working on building a database that has names in it. I have run into an issue with I have two totally different people with the same names. I still need to make a different record for each of t...
Forum Discussion
Megan,
Can you better explain your problem. Is your app preventing you from having duplicate names?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Can you better explain your problem. Is your app preventing you from having duplicate names?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
(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
------------------------------
- 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
------------------------------- 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
------------------------------
