Hi all,

I could use a little help, being a relative newb with FM and all...

I have a db for courses and students, and have a portal that displays who is on each course. This is fine, but I would like to have a button that will draw the info from the portal so that I can email the entire group with one click...any ideas or suggestions sure would be welcome...

thanks for your time...

You have a portal, that's always a good start ... a bit on the meager side relationally:

who is on each course

Strictly speaking is this a 3 table structure,

course--students

This mean that the e-mail address isn't really the portals data, but something referenced from students. The reason for the structure is that students probably takes more than one course and opposite could several students be allowed into halls of learning - hence the many to many structure.

Now to the business, to address all students assigned to one particular course, must the scripting make a GTTR(SO):

http://www.filemaker.com/help/Script-Steps19.html

http://www.filemaker.com/help/ScriptsRef-262.html

...into the enrollments table, from where the build of e-mails is made - I have in the image above made a suggestion as to the way you make personalized emails, mentioning each student by his/her name. You will notice that even though neither each students name nor the Course name is in the enrolment table, are they pulled over the relations.

--sd