append - Can I generate multiple new records based on value in another table, in MS Access 2013? -

i'll qualify upfront admission not professional programmer or database designer. had specific problem solve - need manage great deal of information on employee benefit requests - , limited resources, , built database replace excel spreadsheet inherited. i'm learning go, , i'd find out is, can access i'm envisioning, or need adjust goal?

the main tables database includes employees, requests, tasks, , activity (plus auxiliary tables used drop-down fields, etc.). each employee can have multiple requests, , each request, used tasks keep track of needs done, whom , when, see request through start finish (i'm user of dbase file itself, publish task list report involved). activity, expect, "journaling" feature keep track of what's been done, conversations, etc.

what want speed process of task entry, since requests, taskflow pretty similar. created tables "task owner" , "task categories" - both related primary tasks table - standardize data entry fields, in addition filtering on ("show me employee owns"). tasks has "notes" field can individualize entry without changing drop-downs. it's progress, i'm still spending time adding same however-many tasks each new request set up.

what i've been playing in head identifying tasks sort of code associates them type of request - i.e., employee request tuition reimbursement identified "request type 001" , tasks go tuition reimbursement have lookup field connecting them "001" - when check box or select "001 - tuition reimbursement" drop-down on form, 6 or 8 "standard" tasks automatically drop in tasks subform, they're new records - not "template tasks" i'm querying task categories. want able tweak, edit, update, , delete them, without affecting other request.

i've found lot of information adding new records via append queries, seems limited generating 1 record each "transaction" if makes sense - each time query finds value , performs action, 1 record generated. how access recognize 1 value - request type - , generate each of tasks associated request type new record in tasks?

user selects category of request, such 'tuition reimbursement' multi-column combobox. hidden column of combobox has category code , bound column value of combobox. code save multiple records like:

currentdb.execute "insert tasks(requestid, taskdesc) select " & _       me.tbxreqid & " rid, taskdesc taskscategories taskcat = " & me.cbxcategory  

the real trick figuring out event put code into. should automatic after data element entered or should button click? there need prevent duplicate entries - if user accidentally clicks button again? (this might handled compound index setting in table.) also, new master record created on requests form has committed table first. record committed when closing table/query/form, moving record, or running command save.

as shown, requirement possible, keep in mind "the more user-friendly, more code".

now, when develop code specific issue, post analysis.