Using subdatasheets

Now that you're feeling very comfortable with the term referential integrity and…table relationships, it's time to talk about something that will help you when…it comes to data input, and that's a sub datasheet.…As soon as we create relationships between tables like we have here in our…database, linking the Album ID in the Album table to the Album ID field in the…Songs table, and also linking the Performers table by Performer ID to the…Performer ID field in the Songs table, we now have a relationship.…We've enforced referential integrity so that the way we set it up if we were to…remove an Album, all of the songs with that related Album ID would be removed as well.…

If we were to change information in the Performer ID in the Performers table, we…would see those changes in the related table under Songs here, all the Performer…IDs would be updated.…So with all of that in mind, now we're going to look at a little feature, the…sub datasheet, which is going to help you when it comes to data input.…