QBSystem
5 years agoQrew Member
Using FID from another field
I know that you can use [_FID_1] in formula fields instead of using the label of the field.
My question is if anyone came up with a way to take the field ID from text stored in another field. Let's say I have a field called "FID for First name" and the value is 5. Now when I want to enter the first name in a formula field, I would type. "Hi " & [_FID_{here put the value of the field containing the FID for the first name}]. This sounds like a dream but you never know...
Thanks
------------------------------
Chaim Weiss
------------------------------
My question is if anyone came up with a way to take the field ID from text stored in another field. Let's say I have a field called "FID for First name" and the value is 5. Now when I want to enter the first name in a formula field, I would type. "Hi " & [_FID_{here put the value of the field containing the FID for the first name}]. This sounds like a dream but you never know...
Thanks
------------------------------
Chaim Weiss
------------------------------