Script to find a matching field

[philipcaplan]

As a novice with scripts, I am having trouble trying to construct a script which will work when used with IWP.

I have two Tables within a database.

One Table (called "Members") has two fields: "Name" and "Password".

The other Table (called "test") has two fields: "enteredName" and "enteredPassword".

What I am trying to construct is a script which:

-- takes the values entered in a layout called "StartPage" for the fields "enteredName" and "enteredPassword" in Table:test

-- and performs a Find for the Record where they exactly match the values in "Name" and "Password" in Table:Members.

If Find fails, I want the user to be taken to a layout called "NoMatch".

If it succeeds, I want the user to be taken to layout called "NextPage".

I would appreciate help in how this script should look in FM8.5.

Many thanks. PHILIP CAPLAN