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

Title

Using Find/Script To Move Through Tables

Post

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?

 

Thansk

David    

Outcomes