Hi FileMaker Developer,
I have 3 tables, Table A is 1-to-many to Table B and Table C. I have a layout contsisting one fields from table A and 2 portal showing records from table B and C. The user can add records to table A, B and C as they wish.I want to email to only those records in table C (assuming email field exist). How can I achiever this?
I tried creating a button that will run a script using "Send Mail", and I choose Send via "E-Mail client", create "Multiple emails" (one for each in found set) (see diagram below)
The email was actually sent for the first record of table C and for all record in table A. BUT what I intend to is to send to all record in table C for the record that I am viewing on table A.
FileMaker developer since Oct 2012 I love it!