Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
Please can you tell me how to create a combo primary key
------------------------------
priyanka gummuluri
------------------------------
------------------------------
priyanka gummuluri
------------------------------
You would need to create a formula Text field...
in the formula section have something like:
[Field A]&"|"&[Field B]
You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table.
------------------------------
Ryan Stanford
------------------------------
in the formula section have something like:
[Field A]&"|"&[Field B]
You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table.
------------------------------
Ryan Stanford
------------------------------
- Its still not working . I cannot set it as key
------Original Message------
You would need to create a formula Text field...
in the formula section have something like:
[Field A]&"|"&[Field B]
You might need to add ToText() around the fields if they aren't text already... you then set this new formula field as the primary key of the table.
------------------------------
Ryan Stanford
------------------------------- That is because you cannot set a formula field as the primary key. Is the data being imported in a way where you can create the key prior to import? Or alternatively you can set up a copy of the table and run a table to table import where the key field is populated from the formula field in your original table.
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------ - MarkShnier__You
Qrew Legend
Mark Shnier mark.shnier@gmail.com
2:28 PM (0 minutes ago)
to pgummuluri95Quick 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
------------------------------
