LauraThacker
5 years agoQrew Captain
Re: Can a formula text field be used as the table's key?
Ankit, you can use a formula to calculate the key-value; but you must then push the formula value into a standard text field that you set as your Key for your table. If your table already exists; then you must build the new [Key] text field; populate it with unique values before you can make it the Key.
If your key value is a combination of other field selections separated by a delimeter of some kind; such as [xyz]-[abc]-[def], then you need a formula on your Add-form to "calculate" the Key value. Either when all required values are populated or when the record is saved, push the calculated formula value into the [Key] text field to save.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
If your key value is a combination of other field selections separated by a delimeter of some kind; such as [xyz]-[abc]-[def], then you need a formula on your Add-form to "calculate" the Key value. Either when all required values are populated or when the record is saved, push the calculated formula value into the [Key] text field to save.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------