AnsweredAssumed Answered

Auto Increment Number from Different Table

Question asked by brentjohn on Sep 25, 2012
Latest reply on Sep 27, 2012 by philmodjunk

Title

Auto Increment Number from Different Table

Post

     I have 2 tables (joined by a relation AT_account_type: AS_account_type)

     table #1:Account_Set_Up

     field: AS_account_type (text)

     field: AS_account_number (number)

      

     table #2:Account_Name

     field: AT_account_type (text) {drop down listing AS_account_type}

     field: AT_lk_account_number (number) {lk-up AS_account number}

     field: AT_sub_account_number (number)

      

     I want to increase the AT_sub_account_Number by 100 when the account types match.

      

     Ex:

     New Record #1:

     field: AT_account_type = “Assets”

     field: AT_lk_account_number = “1000”

     field: AT_sub_account_number = “1100”

      

     New Record #1:

     field: AT_account_type = “Assets”

     field: AT_lk_account_number = “1000”

     field: AT_sub_account_number = “1200”

      

     New Record #3:

     field: AT_account_type = “Liability”

     field: AT_lk_account_number = “2000”

     field: AT_sub_account_number = “2100”

      

     New Record #4:

     field: AT_account_type = “Expenses”

     field: AT_lk_account_number = “5000”

     field: AT_sub_account_number = “5100”

      

     New Record #5:

     field: AT_account_type = “Assets”

     field: AT_lk_account_number = “1000”

     field: AT_sub_account_number = “1300”

Outcomes