Include Volunteer Names on Child Records in Excel Reports

Tip of the Week September 18, 2023

In databases, a child record is a piece of information that relates back to one particular record.

Because Excel Spreadsheet reports are designed to be able to contain a very large amount of detailed volunteer information such as service entries and checklist dates, it is necessary to create different worksheets within the Excel workbook to hold all of this information. What’s Inside an Excel Spreadsheet File explains more about how this works. By default, these ‘child’ records relate back to the ‘parent’ record using the volunteer number.

However, if this is confusing, you can change the report to use the volunteer’s name in place of the volunteer number. To do this, select Include volunteer names in ‘child’ records on the Options tab when you create the Excel report.

Don’t like YouTube? Click here instead.

Leave a Reply