I need help creating a simple date range search script. I want to do the following:

1. Click button to begin search.

2. Enter layout with Calendar to select start date.

3. Click "next" button to continue.

4. Enter layout with Calendar to select end date.

5. Click "next" button to continue with search.

6. Go to layout X and print.

Thanks in advance. I know this isn't that hard, but I'm a little overwhelmed with figuring all this out since I haven't used Filemaker since the mid 90's.

Alden

Doing finds across layouts isn't the way to go. You would either need to create all these fields on one layout, use a relationship, or use some kind of dialog plug in that would allow you to have the calander drop down in a custom dialog box.

You could create one layout that looks like a popup. so a script would do the following...

Open New Window

Go To Layout [Date Picker (or whatever you call it)]

Adjust window [Fit]

Then the layout can have two fields: StartDate and EndDate, each field would be a date field so then you could click on the field details and make sure that the pop-up calendar will appear. The layout should also have a Continue or Next button, which will run another script (and a cancel button that will run the script step: Close Window [Current Window] )

Close Window[Current Window]

Go to Layout[Whatever layout you want to print]

Enter Find Mode[ ]

Set Field [ Date ; StartDate & "..." & EndDate]

Perform Find

Print Setup (if you need to adjust the print setup)

Print

Hope this works!

Martha :bigshades: