Calculation Formulas

[fergmj]

I have five groups and several users is each group. Some users have read access to fields on my forms and some have read/write access to other fields on the forms.

I want to be able to say:

If the person entering a new record (making that person the originator) is the CurrentUser, then make them a part of the group "originators" instead of the group "sales" that they are placed in when they logged in with the password "sales123"

Any help?

Thanks

fergmj