Forum Discussion
priyankagummulu
Qrew Trainee
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
------------------------------
MichaelGrosky
5 years agoQrew Trainee
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
------------------------------
------------------------------
Michael Grosky
Director of Customer Strategy, Sympo (Gold QSP)
mgrosky@sympo.com
------------------------------