7 Replies Latest reply on Sep 27, 2012 8:46 AM by philmodjunk

    Auto Increment Number from Different Table

    brentjohn

      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”