Phil - Tuesday, January 12, 2010 5:01 PM:
As far as I can tell, there is no ID field in the Identity table that can reference back to the users table.
I ask this because I want to accomplish the following, given an Identity (Alias) item, I would like the pull the associated users logon name.
The only way I see to "get back" to the User table from the Identity table is through names...which is not preferred as obviously you can have 2 people with the same names.
Thanks for the help yet again!
RobMcAveney - Tuesday, January 12, 2010 5:06 PM:
There is a relationship named Alias from User to Identity. Open a User in the form, then toggle off the Hide Tabs button on the toolbar and you'll see the relationship.
Rob
solbsg - Thursday, April 29, 2010 4:52 PM:
For example, I have a person name John Smith and he's General Manager. I have to create an identity named General Manager and in user upgrade information about John Smith and then get into the relationship and set the alias??
It's correct??
