Linking two modules within CRM.

Linking two modules within CRM.

I work for a digital marketing agency.  Right now, whenever we convert a lead into a contact, it will put that lead into the "Accounts" module.  What we want, is that whenever we select a project as "Active" under the "Rating" field in the  "Accounts" module, that a corresponding record will created in our custom module, "Current Accounts".  The idea is that the "Current Accounts" module will contain ONLY our active clients, all based upon whether or not the "Rating" field under "Accounts" is marked as active.

I have everything up until the custom function figured out.  Anyone have any advice/information that could help?