This is a pretty simple 2 table, 1 relationship problem.
and there are only 2 layouts: Transactions and Accounts:
Here is the transaction layout:
and here is the Accounts layout:
Each account is either a Expense or a Revenue account. On the Transactions layout,
the user enters (in the yellow field above): Check (Expense), Deposit (Revenue), Bank Fee (Expense) or
Dr Card (Expense).
Since each Account Description is either an Expense or Revenue account, I need a way to
limit the Account Description dropdown to either Expense or Revenue accounts as dictated by
the users entry as: Check, Deposit, Bank Fee or Dr Card ... (Expense, Revenue, Expense, or Expense)
I "get" dynamic value lists but can't seem to grasp how this might come together.
Thanks for reading...