I've seen this before, but trying to figure it out has gone beyond me.

I have a layout that displays a few fields for a record. I also have a layout setup to help in finding records based on cross reference numbers. If the user looks for a certain number and finds more than one record, I'd like to have a list that a user could choose from to view in the main layout.

The only thing I can't find is how to do an "If" if the "found set" is more than one record, so I could instruct FM to either change to the list view or even to another layout that could accomodate the user for making their choice.

Anybody got any ideas? I've seen this in another FM database a couple of years ago...

In a script user the following

If (Status(CurrentFoundCount) > 1)

Goto Layout X

Else

Goto layout Y

EndIf

Hope this helps

Ah! 1,000 Thank yous!

Now - where, may I ask, di you get or learn this information? I've got a few books on FM, but they didn't cover this aspect of FM in any great detail - any recommendations?

Hit the help key and look through the Status () functions. There are quite a field good things there. Error codes are also worth a look.

-bd