AnsweredAssumed Answered

"go to related record" query

Question asked by ray-lomas on Mar 2, 2009
Latest reply on Mar 2, 2009 by ray-lomas

Title

"go to related record" query

Post

Hello,

I've two questions, firstly can anyone recommend a good reference book which goes through scripting for filemaker? Preferably without putting one to sleep.

My second is a scripting question.

I have a Fault Log that I would like to "go to related record" linking back faults to pieces of equipment. The assets database that the "faults" database links back to is split into UK and US, essentially the same thing just different currency etc.

How do I get the "go to related record" to one layout over another? Certain records want to link back to London and others to the US, I have both fields. My best guess is:

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 If

Many thanks in advance,
Gus

Outcomes