Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
One of the bonuses of creating relationships is that you can then see sub data sheets within your tables, without to having run a report. Open up your SalesReps table, notice the Plus sign to the left of my data, click on the Plus sign, next to Jordan Hinton and you'll see all of his customers, then click on the plus next one of his customers and you can see all of that customer's orders. It would be handy to get some statistics on these orders, click on the Totals button up in the ribbon near the center.
Now a new Total row opens and you can click at the bottom of each cell to get a dropdown that has a number of different statistics that you can see for each order, this totals rows is covered in detail and the totals video in the course, click on the Minus sign to close Avulon. Now here's a slick trick, this gray box in the corner of the sub datasheet allows me to expand or collapse all of the sub datasheets at that level, let me show you how it works, click on the gray box and you will notice that the whole thing turns blue, then click on the Plus sign and not only does Avulon open, but I can see all of Jordan's customer orders complete with the total row, if I turnoff total row it'll disappeared from all of them and if I click back on that gray box again, I can now collapse all of them all at once with one click.
Using these sub datasheets gives you a convenient quick glimpse into how you data flow in your hierarchy.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74959 Viewers
80 Video lessons · 129933 Viewers
52 Video lessons · 64111 Viewers
59 Video lessons · 49904 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.