I'm using several dynamic fields in a workflow and would like to know how utilize the dynamic fields better.

- What the workflow does now:

A user picks 'Department'. A Dynamic Field then looks to a SQL Table with Codes that correspond to that 'Department'. Therefor when a user selects the 'Code' field, they only see the Codes associated to that 'Department'.

They select a 'Vendor' Field, another field called 'Vendor Number' automatically populates using dynamic fields and a different SQL table.

- What I would like to do:

A user selects a 'Department', they then select a 'Vendor'.

IF that 'Vendor' has a 'Code' assigned to it

   THEN 'Vendor Number' and 'Code' will automatically populate.

ELSE (There is no 'Code' associated to a 'Vendor')

   THEN 'Vendor Number' automatically populates, and the list of 'Codes' associated to the 'Department' is available in a drop down list.

There would be a 2:1 relationship on the 'Vendor' field. How can I achieve this within Laserfiche/Workflow?