Combo Primary Key
How do I set two fields in a table as a combo primary key, like in Access? Thanks!
Forum Discussion
thank you! I'm a brand new user to Quick Base, so I'm not familiar with how to make a hyphenate formula or use the API_SetKey Field. Would you mind elaborating?
- Please can you tell me how to create a combo primary key
------------------------------
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
------------------------------- 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
------------------------------
