Jump to content

search based on specific field


This topic is 2612 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2612 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.