If I'm reading that right, the consultant logs into your database. Their ID needs to be added to any new Client they create. If their login user name is not the same as their ID, capture their ID on login with a global variable, and set the ConsultantID to the global variable when they create a new record.
1 of 1 people found this helpful
If you set a global variable, say $$ConsultantID to a value on log in as has been suggested, you might set up an auto-enter calculation:
To automatically enter the value of the variable each time a new record is created in that table.