AnsweredAssumed Answered

Self Join Relationship

Question asked by BryanN on Apr 23, 2014
Latest reply on Apr 25, 2014 by BryanN


Self Join Relationship


     Ugh, for some reason this isn't working.  Here's what I have

     Battery_data table

     - has fields "cell number" and "volts". "cell number" should count up from 1 to inf in whole steps of 1, i.e. 1, 2, 3, etc as long as they are related to the same parent table (test_report).  So if they have the same fk, they should count up.

     - Have a self join relationship for this table, with fk_testreportid = fk_testreportid being the relationship criteria, 2nd table occurrence called battery.autocellnumber

     - "cell number" has auto-entered-calculation with the formula "Max ( battery.autocellnumber::cell number ) + 1"

     It's inserting "1" every time as records are created in my portal and can't figure out why.


     Any thoughts?