Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
Im completely new to quickbase and can you please guide me in creating a primary key with two fields where the two fields are foreign keys
------Original Message------
The form rule method could also work, however a limitation that you could encounter is if you data is being entered via grid edit or import as opposed to using a form.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
Sure:
1) Add a new field to a table setting the field type to Formula - Text
2) in the formula box in the field settings, select [Field1]&[Field2]
Note that each field should be surrounded by [] and the & is to concatenate the two fields. Your field types will also have to be text for Field1 and Field2. If they are not you can convert them in the formula totext([Field1]&[Field2])
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
1) Add a new field to a table setting the field type to Formula - Text
2) in the formula box in the field settings, select [Field1]&[Field2]
Note that each field should be surrounded by [] and the & is to concatenate the two fields. Your field types will also have to be text for Field1 and Field2. If they are not you can convert them in the formula totext([Field1]&[Field2])
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
- MarkShnier__You
Qrew Legend
Priyanka,
It looks to me form your screen shot that one of your fields is a lookup fields, and you are trying to use that in a formula field being marked as Unique. A lookup field may not be used that way, because if the value on the lookup field changed at its source, then there would be no way for QuickBase to enforce Uniqueness.
you would be able to use the field [Related Item] though in a formula to be Unique.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------ - i want the field to be unique but if im trying the way you suggested me its accepting duplicate values as well.
------------------------------
priyanka gummuluri
------------------------------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------- Its showing an error . If i try it.
------Original Message------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - Can you share your formula and the properties of the fields that you are using in the formula?
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
------------------------------
priyanka gummuluri
------------------------------- Will your Order ID always be unique? If so, mark that field unique as well and then try marking the formula unique as well.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - I have marked orderid as unique and tried but still showing the same error message "This formula is incompatible...."
------Original Message------
Will your Order ID always be unique? If so, mark that field unique as well and then try marking the formula unique as well.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - Thank You . Thanks a lot it worked
------------------------------
priyanka gummuluri
------------------------------
