Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
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
------------------------------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
------------------------------
priyanka gummuluri
------------------------------
- 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
------------------------------ - 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
------------------------------
