Mark,
In magic application we have the user repository to create the user logins (user/employee id and user password) and we also create the same user /employee id in the employee table in the database table and enter all employee related details. When someone logins to the application, it authenticate the user id and password from the magic repository user login and if we need the employee in our application we use the employee table from the database.
I simply need to learn doing the same concept in awareim.
Thanks
Sabbi