AnsweredAssumed Answered

Script update not showing and relationship tables

Question asked by snimmo on Dec 20, 2012
Latest reply on Dec 20, 2012 by philmodjunk

Title

Script update not showing and relationship tables

Post

     I have two issues that I think might be related. First, I have a script;

          if [Score By Hole::Score Type = "Birdie"]

             Set Field [Score By Hole::Gross Score[CourseHole::Par - 1]]

         Else if [Score By Hole::Score Type = "Boggie"]

            Set Field [Score By Hole::Gross Score[CourseHole::Par + 1]]

         Else

            Set Field [Score By Hole::[CourseHole::Par]]

        End If

        Commit Records / Requests []

     -------

     Don't really know if I need the commit statement.

     Anyway, the debugger indicates the logic is working in the script as it seems to be firing off and going through code. I am not, however, seeing any change in the layout display for the Gross Score field even though the debugger shows it going through the set statement.

     The second issue which may be related is that the value for Par is from a related table that goes through about five tables in the relationship graph before the two are connected. My question on the relationship is - Am I better off create more less complicated relationships than trying to have one humongus relationship that ties everything together. I'm not sure I understand whether you can have multiple relationship graphs without causing overhead or confusing the system. There are a lot of tables in this database that tie together but in trying to minimize data I have created quite a few tables that tie together with ids from the other tables.

     Thanks for your help.

      

Outcomes