Matthew Porter 5/4/2009 2:03:42 AM
Aparently, this CAN be done (with a bit of fiddling).
For those of you who are curious, here's how:
1. Create a new table called "Users"
2. Add a column called "User ID"
3. Add a column called "User Name"
4. Set the "User ID" column as the "Key Column"
Now you can link to the Users table using the "Record Owner" column from any other table, and bring in the Lookup value of "User Name" where you need it! :)
You can also add any other profile fields you need.
The only "down side" to this approach is that you have to manually create a new User record any time you create a new user ... but that's fairly easy for most people.
Kirill, this might be a good blog post and/or video idea! :)
As an aside, perhaps TD can add this entity by default as a "starting point" to every application (or provide the option to do so via a simple checkbox).