I have a database which contains:
table titled workshops (there is a field in this table which contains the below mentioned presenter and a workshop id)
table titled presenters (the presenter table contains a field indicating whether these people are employees or not and a field with their email address) the two tables are related
I need to:
create a find for the presenters who are employees (I can do this)
Can someone help me write a script for this?
then based on that find I want to generate an email to each presenter and attach a pdf of each record (workshop) associated to their id.