Selecting items from another table for mass mailing.
I'm new to filemaker and i'm working on a solution for my music platform. Wat i'm trying to do is this (simplified).
I have two tables, persons and companies, with selection criteria so as is_artist, is_booking agency, etc. And different email adres fields.
Now i'm building a layout, in a new table, for composing my mails, with header, footer, containerfields for inline pictures etc.
next to this layout i put checkboxes to be able to select a specific group, for example all companys with booking agency checked and the email adres and name of the persons doing the artistmanagemant in this agency's.