Auto-populate fields from one table into another
I've created a project table to record ongoing projects. Separately, I have a tasks table that lists activities that are associated to ongoing projects.
I created a relationship between the two tables without a problem; however, what I would like to do is have a set of pre-determined tasks automatically populate into the project table based on a drop-down field selection within the project table. Example: In my project table, if I select the event type as "webinar", I'd like all the assignments from the task table that relate to a webinar to automatically appear in the projects table. Can this be done?
Thanks everyone!
------------------------------
Gwen Peters
------------------------------
I created a relationship between the two tables without a problem; however, what I would like to do is have a set of pre-determined tasks automatically populate into the project table based on a drop-down field selection within the project table. Example: In my project table, if I select the event type as "webinar", I'd like all the assignments from the task table that relate to a webinar to automatically appear in the projects table. Can this be done?
Thanks everyone!
------------------------------
Gwen Peters
------------------------------
