mySQL trigger on record that creates a new table

[Michael Fayol]

It's been quite a few years since I have done DB work. MySql backend (thru workbench) and I am using MS Access as a frontend.

I have a base table that I am multilinking (basically a name column, and # of months column). Through a form, the table is updated (a record added) and I want that new record to trigger an event that creates a table and that table is named based on what the user inputted in the form/record, and create columns for the months - just named month1, month2, etc.

Any thoughts on how to do this? Any thoughts on a better way to do this? lol

I am also looking for recommended reads/videos to get me back up to speed.
Thanks!