I am having trouble writing a script which is supposed to look through all the records in the database then enter a find mode layout i have made, then perform a find on the records that fit the criteria.
Basically what i have is a field that asks if the user would like to select a record for editing. Then i would like file maker to perform a find with the criteria for the field select record for editing with the value of "yes".
I have one method which just checks all the records and omits the records that have a "yes" value for the field select record for editing and then i just show the omitted records
which works,however there is a flaw to that algorithm
if they were to accidently press the button that is linked to the script after it has omitted the records wanting to be edited. then file maker will show the records that were not selected for editing and leave out the ones there were selected for editing.
Im sure the method of going into find mode and using the perform find scipt with a criteria is the correct way of doing it, however the script i wrote for this method is not working properly.
I currently have this for the script:
Go To find mode layout
Perform Find[restore]
and for the specify on the perform find
the action i have is Find
Criteria is supposed to search the Field
Select Record For Editing: [YES]
with a value of yes.
from here i want those with a "yes" in that field to be isolated from the other records
Basically what i have is a field that asks if the user would like to select a record for editing. Then i would like file maker to perform a find with the criteria for the field select record for editing with the value of "yes".
I have one method which just checks all the records and omits the records that have a "yes" value for the field select record for editing and then i just show the omitted records
which works,however there is a flaw to that algorithm
if they were to accidently press the button that is linked to the script after it has omitted the records wanting to be edited. then file maker will show the records that were not selected for editing and leave out the ones there were selected for editing.
Im sure the method of going into find mode and using the perform find scipt with a criteria is the correct way of doing it, however the script i wrote for this method is not working properly.
I currently have this for the script:
Go To find mode layout
Perform Find[restore]
and for the specify on the perform find
the action i have is Find
Criteria is supposed to search the Field
Select Record For Editing: [YES]
with a value of yes.
from here i want those with a "yes" in that field to be isolated from the other records