I wan to create a basic appointment tickler that will pop up when a medical database is first started up.

I would like a layout to pop up that lists the appointments from the current date out to 7 days from the current date. I was told I might be able to do it using something along Get (CurrentDate)...Get(CurrentDate)+7.

Is this done with a startup script or with thhe defining of the fields in the layout? Can anyone show me how I would write a startup script that would make this happen?

The table with the medical appointment data is called MedAppoint. The fields I want to show are MedAppName (name of person the appointment is for), MedAppDate (date of the appointment)& MedAppType (type of appointment). I have a layout I created for this called MedAppTick (the tickler layout).

Thanks!

You would do it with a startup script that you set in the file options. The script would look something like:

Enter Find Mode // make sure pause and specify are unchecked

Go to layout (MedAppTick)

Set Field (MedAppDate ; Get(CurrentDate) & "..." & Get(CurrentDate) + 7 )

Perform Find // make sure pause and specify are unchecked

Thanks Fitch! That did the trick.