Hi Gang,

I am trying to setup the ability for users to print their own selectable range of records. For example each record has a sequential number (1,2,3,4...)ID field. I want the user to be able to select a range of records to print. This would then print a columnar layout with the proper range of records. I would prefer NOT to have the user select this in the "Print" dialog screen. Can this be done via script with 2 fields?

Many thanks,

Nando

Why not give the users a Find layout where they can enter find criteria, have your script perform that find, then go to the proper layout and Print?

Thank you. I am very new to FM. I did try to create a new search criteria, but I am confused as to why I cannot enter a second (and third) field as my search criteria.

If the user wants to search/print records 6 to 10, I would like to do a search criteria like Id. No >= SearchStartField and <= SearchEnd Field. The search criteria wants me to enter a specific value and doesn't give me the option of specifying a field.

Thanks,

Nando

While in Find Mode, you can only enter explicit values. But you can use globals to hold those ranges, then use a script to Set the search range from the globals.

Say you have a couple globals to hold your search range, gSearchStart and gSeachEnd.

Now the script to search this range would be:

Enter Find Mode []

Set Field [ ID No ; gSearchStart & "..." & gSearchEnd ]

Perform Find []

Of course, if you're holding your range valuse in globals anyway, you could also get the records in that range by using a relationship,

Thanks again..!! It works great! This is exactly what I was looking for.