How can I stuff a new record with data from another table

I have some data in Tablename Criteria, with one record only with a field named Criteria (Med Text Field).

My Main Table is called Students. it's records have a field named Criteria (Med Text Field).

I need a code snippet which will "stuff" the data from the record in Table named Criteria

into the new record in Students whichis appended when someone registers.

Here's the url: http://www.czvr.ca/students/
Thank You!