I am attempting to create a Petty Cash database that will ultimately
print a pre-designed petty cash receipt, a report on expenditures by
account number with account name, and a report which will show the
transactions for a given period and a balance.
I currently have three tables, Petty Cash, Expense, and Account Number.
Petty Cash table has all the fields, Receipt No, Date, Payee, Amount,
Purpose, Expense and Account number.
The Expense table has one field for Expense Name. The Account number
table has one field with all the account numbers related to the Expense
Name.
My question is how do I link, on an data entry access form, a drop down
list for Expense so that it will pull up the correct account number for
the expense selected. (The users will be non accountants)
Any help would be greatly appreciated.