search based on specific field

[pasin]

Hello everybody,

I am a newbie in filemaker and this is  my first script.

I have 2 tables: artist and ebookartist.

First table contain name and surnames of artist, second table contains eboo titles of artists.

What i want to do is create a script  where you type the name of an author on a filed in a layout and you get a list of ebooks of this artist.

Thanx in advance!

[Kris M]

http://www.filemaker.com/help/11/fmp/html/scripts_ref1.36.73.html#1030378

[pasin]

Ok, but how can I take the value from the field, I mean not a db field but an edit box?

[comment]

First table contain name and surnames ...

What i want to do is create a script  where you type the name of an author

 

First, you will need to define a calculation field cFullname =

Name & " " & SurName

Otherwise, if someone searches for 'Leo Tolstoy", they won't find anything because neither Name nor Surname contains both.

 

Next, define a global text field gSearchName. Then your script can do (roughly):

Go to Layout [ Books ]
Enter Find Mode []
Set Field [ Authors::cFullName ; Authors::gSearchName ]
Perform Find []

Note that this does not include error-handling in case no books are found.