Once the transactions and categories tables are complete we use a lookup in the transactions table to look up the category in the categories table. We open the tables in the relationships window and change the join to ensure referential integrity. In some fields we change the required to YES to make sure that the person entering enters something in this field.
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.
