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------------------------------
Original Message:
Sent: 09-10-2019 14:44
From: priyanka gummuluri
Subject: Combo Primary Key
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
------------------------------