The relationship between the video sites and the video distributors is also many to many. This is because one distributor can distribute to many video sites and one video site has sometimes more than one distributor. I therefore need a table in between and use lookup for the relevant fields. I then go to the relationships window to ensure referential integrity.
Free Database Tutorials From VTC:
Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97
Database Optimization
Data Modeling
Visual Basic for Access
For more free database, programming or software tutorials click here and do a search or click one of the categories.
