Visual Basic Database Relationships

In some cases it wouldn’t make sense navigating 500 records of products who have been purchased by the same customer.
Wouldn’t it make more sense navigating 1 record and viewing the 500 products in a Gridview?
Maybe you have 3500 customers who have purchased several products, think of how many times you would have to navigate to view all customers and products…It would take a long time.
This is where we need to rely on data relationships.
Data relationships allows you to connect…say a customers table to a products table.
All products a customer purchases will be available by viewing the one record…the Customer record.
If i have purchased 25 products and Jane purchased 13 products, i could than view all products i have purchased under 1 customer record than i can navigate to Jane and see all 13 products she’d purchased.
This project shows how something like that would work.
This project is a simple contacts project.
You can create individual users who have multiple contacts.
Click the link below to download the project
dataRelations