Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
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
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendPriyanka,
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
------------------------------
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
------------------------------
- Thank You . Thanks a lot it worked
------------------------------
priyanka gummuluri
------------------------------