Hi,

I'm very new to Filemaker and am having difficulty being able to manipulate the 'current record'. In particular, if I do a search on a field which returns multiple matches, I then display this set of records in a list layout. When the user selects one of these for further examination I want to take the user to a Form layout which shows him/her just that one record and I can't seem to do that - the window shows all the matching records in the form view (though starting with the selected one). Any suggestions on how to limit the form view to just the one selected record would be much appreciated.

Also is there any way to select one record from many in a list view by, for example double-clicking that line, rather than having a button at the bottom of the list that records the line I have clicked on? I would like the double-click then to take the user to a form view of that record.

Thanks.

In the Menu bar (at top), View as Form will present a single record view. In your List view, put the button in the record (row), instead of at the top or bottom of the layout. Then it can run a single step, Go to Layout ( your form view layout). Put another button on the Form view layout to return to the List view layout.

FileMaker remembers which view you used last on a layout, Form, List or Table, and will present it as such.

You can also script this, if you want to add something like an Adjust Window [ Resize to fit }.

Thanks very much for your reply Fenton. The button into the list view is great, agreed it does save a step (even if it does show once for each record).

However I can't get the single record to show correctly in a Form layout. I need to script it all - so no menus for the end user.

When I display the selected record from the list it shows as just one of many (all the ones in the list). Even Adjust Window [Resize to Fit] still shows multiple records - in Form layout.

My script is something like (ignoring error capture)

1) Perform Find[]

# then having found multiple records

2) Perform Script["SelectFromList"]

# while in the "SelectFromList" layout the 'Select' button in the list layout does a Resume Script

3) Pause/Resume Script [indefinitely] #seems to be the most common line I write

4) Go to Layout["EditPatient"(Patients)]

I just can't seem to stop the program showing me all the records from the list (even though I have selected just one in a list layout and inserting an Adjust Window after step 3 or 4 still shows all these records. Do I need to do something else in the 'Select' button for example?

If you can advise further that's be great.

Robin

Well I feel stupid. When I exit and restart the database and I put a View as Form line in the script it works fine. Thanks again for your help.

R.