AnsweredAssumed Answered

FM 13 adv ... dynamic value list...

Question asked by synergy46 on Jul 26, 2014
Latest reply on Jul 27, 2014 by synergy46

This is a pretty simple 2 table, 1 relationship problem.

Relationship333.png

 

and there are only 2 layouts: Transactions and Accounts:

 

Here is the transaction layout:

transactions333.png

 

and here is the Accounts layout:

Accounts333.png

 

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...

 

R

Outcomes