Script update not showing and relationship tables
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]]
Set Field [Score By Hole::[CourseHole::Par]]
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.