please help me Relate two tables through the ID number.  Create data
entry views with pick lists and data entry error checking for the
customer file and the transaction file.  Have the account balance in
the customer file be updated by transactions in the transaction file. 
Enter at least 3 transactions for each of a minimum of 3 customers and
check the functionality of the database. and Create a query that
orders the customer file by account balance in descending order.