Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend
|
2:28 PM (0 minutes ago)
|
 |
||
|
||||
Quick Base used to allow a text formula field to be designated as a Key field by using an API command to set the Key field. But when I used this technique I ran into technical bugs and recently they have prevented the Key field from being a formula field.
Hence we are now back to the old method, which is typically to have a field to calculate the key field by formula and then have a form rule enforce it and copying the value in the formula field to the Key field.
Mark
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
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
------------------------------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------
- 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
------------------------------- i want the field to be unique but if im trying the way you suggested me its accepting duplicate values as well.
------------------------------
priyanka gummuluri
------------------------------
