AnsweredAssumed Answered

Using Find/Script To Move Through Tables

Question asked by thudpucker on Jun 16, 2009
Latest reply on Jun 16, 2009 by philmodjunk


Using Find/Script To Move Through Tables


Hey all.. I'm a SQL guy that's trying his hand at FileMaker..


I have three tables.. A, B, C. Table C has keys from both A and B. A and B do not share keys.


I'm trying to write a script that will start out on Layout A, and use those keys to search for items in table C, and display them on the layout?


 So far I have:

GoTo Layout["C"]

Enter Find Mode

Set Field[A::Primary_Key]

Perform Find[]


But I'm really getting stuck on the Specify Find Requests, and how they work.. And I could be going in the completely wrong direction here. Can someone steer me around?