Find Record in a other table

find record

April 17, 20169 yr

Newbies

Hello friends,

I'm new to FM so if this topic isn't in the right section. I'm sorry for that.

I have a small database that contains 3 tables. In on of the layouts you enter data about activities a client does. I'd like a button on that layout to go to the client record. Witch of course is in a client table.

I used the standard script functions Go to record DB_GV_Clienten::Naam & DB_GV_Clienten::Achternaam

Thanks in advanced

April 17, 20169 yr

16 minutes ago, Erik Nld said:

I used the standard script functions Go to record

That's the wrong script step to use here, as it will go to a record in the current table - and it will look at the referenced field for the record number to go to.

Use the Go to Related Record[] script step instead:
http://www.filemaker.com/help/14/fmp/en/html/scripts_ref1.35.22.html#1139541