AnsweredAssumed Answered

performing a find...

Question asked by icecreamboy on Apr 21, 2010
Latest reply on Apr 21, 2010 by icecreamboy


performing a find...




I'm using FileMaker Pro 11 Advanced on Windows XP. So I realized that in Form view, the middle-scroll wheel doesn't scroll up and down the page, but it does in List view, and I find this scrolling to be very convenient.


What I'm trying to do is have a "New Record" button, done in List View, that makes it so the currently found set of records is only the new record. This emulates the Form view, and keeps the scrolling of List view.


I've come up with this script but it keeps saying it can't find any records:


Freeze Window

Enter Browse Mode []

New Record/Request

Commit Records/Requests [No dialog]

Set Variable [$id; Value:Patients::Patient ID]

Enter Find Mode []

Insert Calculated Result [Select; Patients::Patient ID = $id]

Perform Find []

Enter Browse Mode []


My logic is, create and commit a new record, get its primary key (Patient ID), perform a find for records with that primary key, and voila, I would think that I just get a List View of my new record.


Could someone please tell me what I'm doing wrong? Any help would be very greatly appreciated! Thanks :)