Skip to main content
Question

Adding Child table report to Email

  • March 3, 2025
  • 0 replies
  • 63 views

Forum|alt.badge.img+9

I am trying to create an email notification for a parent table.  This table has a one to many child table for items to include with the parent record.  I would like to include the child records associated to the parent record in table form.  Not a link to the report.  How would I call the child records in table format to be included on the email notification?

Thanks

Brian

MarkShnierYou
Forum|alt.badge.img+24

A low tech solution is to make a form specifically for the email and send a copy of the form in the Notification.

Another option is to make a super mini form with just the child table and then make your notification with the fields from the parent record you want and then include a Copy of the record below that text, and specify that super mini form with just the child table records as the form to use.


Forum|alt.badge.img+9
  • Author
  • Registered
  • March 3, 2025

Thanks Mark,  I didn't have the "Display the related item records directly on the form" checkbox checked.  Ughh 

Thanks