This video shows that by using a lookup we create a relationship between two tables. The relationship is one to many because one field in one table appears many times in the other table.
We force referential integrity which means that if the data is changed in the one table then it will get changed in the other table. Also if the record is deleted in one table it will automatically be deleted in another.
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.
