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.
More Free Video Tutorials - http://DatabaseMentor.com