Welcome to the Forum!
If I understand correctly, I think you're already there...If (Fault Log:: Office = "London" )
Go to Layout ("UK Assets - Info" (UK Assets)Go to related record (from table: "UK Assets"; Using Layout: "UK Assets Info" (UK Assets)Else If (Fault Log:: Office = "LA" or Chicago" or "New York" ) Go to Layout ("US Assets - Info" (UK Assets)Go to related record (from table: "UK Assets"; Using Layout: "US Assets Info" (UK Assets)End IfYour layout choice is stated within the go to related record command. Your trial script did it twice which might cause some relational issues (maybe, maybe not). One major thing to check is how your table occurences are set up so that you actually go to the record(s) you want. I'm assuming you have FaultLog:: Office related to UKAssets:: Office and a similar relationship for the US. If not, how do you have the relationships set up?Let us know how it's working...
Thanks for the quick response. You cracked it, I had the Go To Related looking at the Field in the Fault table rather than the Assets.
I've been scratching my head all day over that!
Any suggestions of good a scripting reference guide?