Hi

I am new to Filemaker and this can be easy.

How about this situation: I have a form with 7 fields. I need to find all
the records in the database where values in two of the fields are the same
as in the current record - just like in the situation where I am looking
data of a customer and want to see the history (every record) of that
customer.

I know how this is made with Access but I can not find a way to do this
using FM script.

Juanle <juanle (AT) optirad (DOT) com> wrote:

If you have separate table for customers you may create a relation
between that and your present table and then use the "go to related
record" script step.

If you must do it in the present table, create 2 global fields and tell
teh script to fill the global fields with the contents of the 2 fields
in questions (set script step). Then the script needs to go to find mode
and perform the same set field steps, just inverse (from the globals to
the actual fields), and then do the find.
--
http://clk.ch

Hello Juanle,

How you do it depends on what you want to achieve and to some extent which
version of Filemaker you are using - I assume it is v7 as you are new.

For example I would probably want this data available at all times, in which
case you construct a relationship from the table to itself matching the two
fields of interest and then place a portal on your form showing the records
from the related data.

If, however, you want to do a scripted search and look at the data in a different
layout, maybe a list, and have the search linked to a button on your layout
then you will need to store the current values of the two fields go into
Find mode place the values in the fields and then perform a find.

I am being somewhat vague because we really need to know how you want to
view the found data.
My preference incidentally is the first method because once it is set up
there is nothing else to do.