Subject New records in link tables
Author petesouthwest

I have a contacts database for the educational resources that we are
developing, with the following tables:

Organisation -< Contact -<Contact_Exam >-Exam

When we add a new contact we will need to add a record in the
contact_exam table linking the contact with the type of exam they are
responsible for.

I was wondering if this record could be automatically generated by the
database somehow or whether it should/can only be/ generated by my
frontend software.

If it can be automatically generated by the database, could you point
me in the right direction please!