Using User Fields in Connected tables
We have many apps that use employee tables, and every time we have a new hire or someone changes departments, we need to update all of these tables. So we created a master table and connected it to ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI suggest that you just use that text field as the key field. You can calculate that value from a any user field or the Current User
User()
from any other table
ToText(UserToEmail([My user field])))
and make your relationship and look up any Fields you need from your user table
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks.
If the Related fields in the child tables are user fields, will they recognize each other?
------------------------------
David Pontier
------------------------------- MarkShnier__You
No, they will not. That's why you need to make a Formula field on the child table to convert the user field into a plain text field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
