Creating basic relationships between tables

- [Instructor] Relating the tables…in your database is pretty serious business.…Relationships are the cornerstone of a relational database…but it's incredibly easy to create the relationships.…Now, I'm going to do that by hopping over…to the database tools tab, I'm gonna click on relationships,…and then, if it doesn't appear on its own,…the show table dialogue box, I click the show table button.…Now, the show table dialogue box lists all my tables.…I could have tables that aren't going to be involved…in any relationships but all five of mine will be…and I'll give two ways to add them to this workspace.…

You can double click on them.…Or you can click on them and hit the add button.…I find double clicking easier.…Let me just move these out of the way…so that you can see them up here.…I'm gonna double click on orders,…then products, and then vendors.…And then I close the dialogue box.…Now, I'm gonna spread them out…because, believe it or not, the method…by which you relate them is to drag from box to box,…and the more room you have in…