Create user profiles based on current user
Before the question, come detail about my database:
The database login is accomplished via means of an Open Directory sever, and there will ultimately be around 1000 unique users. I have set up a "User Profiles" table that contains the following fields: ODUserName, FirstName, LastName, FullName, Email, Manager, Manager Email.
The question: is there any way to have the database check the username of the current user at login against the data in User Profiles table, and auto-direct the user to create a profile if one doesn't exist for their OD User name?