I am upgrading from FM3 to FM6 at the moment and within a few weeks to FM7. I'm using 6 as a jumping off point just to clean up some of the crap in this app I inherited.

Anyway, this is a db for a hospital. The first layout is the "FIND PATIENT" layout. The search can be done by a number of fields such as last name, first name, ssn, etc

Now what I need it to do is have like a check box that says "SEARCH ARCHIVES". When the box is checked then the archived (ie closed) patient files are searched as well as the active files.

If the box is empty, then just the active files are searched.

I'm leaning to possibly doing buttons that go to different layouts to do the searches. Either that or looping over the results and taking removing the ones that are archived if they are not wanted. (The users tend to just type in partial names and then select from the list that shows up)

But is there anyway of just saying IF archiveSearch == TRUE search all else search archiveFlag <> "X" ?

I assume that you mean that you want a search that will return only active files results or all files results. The search will search the entire database.

You need a flag on the files that indicate that it is an active or archive file. This can be a simple "0" = active, "1" = archive. I'll assume that you already have some type of indicator flag.

You can accomplish what you want by either creating two separate search buttons/scripts, a search actives and a search all and in the active include, after the enter find mode step, Set Field (Flag; 0), in the archive use only enter find mode

If you wanted to use radio buttons to indicate search archives then you write one script with an If statement after the enter find mode step

If (Archive = "NO")

Set Field (Flag; 0)

Phil