Score

Score

Hello,
 
      I am working on retrieving a score based on a chioce that a user makes from a drop down.  I have the following forms:
 
  1. Policy Write-Up (Database) - This is where I have a database of all the possible policy violations and a point number attached to each.  The fields are:
    1. Policy Number
    2. Policy Violation
    3. Policy Rule
    4. Points
    5. Write-Up Data - This is a formula that combines Policy Number + Policy Violation + Policy Rule
  2. Write-Up - This is where I want the user to be able to enter in an employee write-up.  On this form, I would like the user to choose the Violation (this is a look-up field that displays the "Write-Up Data" from above) and then have ZoHo fetch the point value from the Policy Write-Up (Database) based on the chosen Violation using the Actions on User Input or Update ..
     Any help would be greatly appreciated.
 
Thanks
 
Nick