Your search parameters make no sense. To me anyway. Text for layout name? A find is based on a layout or rather the underlying table. No need to search for it. Text for tap? What's that mean? You don't search for a row or column number. Perhaps a little clarification will serve to get you some help.
I perhaps badly expressed myself.
This table is done to identify a button on a layout, a tap in this layout at the position row/column.
When a button is selected, a script search in the table which actions must be done.
All buttons in layout and tap run this sripts and following the table the script can launch a script, with or without parameters if the buttons is enabled and authorized.
To choose what to do, I must know from which layout, from which tap in this layout, from which row and from which column, the button was pushed.
Modifying the table, I can modify the role of each button without having to modify the layouts and taps on layout. When description is empty for example, the button is hidden and inactive.
You can consider that I search for 2 strings and 2 numbers in a layout. When fixing the first field with a string with or without the three other fields I got an error. When searching with only the three other fields, I get a collection.
Why it's work with 3 fields and not with 4 fields ?
Your file seems corrupted. "View Index" and "Show individual words" on the field showed nothing. After recovery, the log says "Recover built a new database without detecting any problems." but now new file shows words.
I actually forgot to check this point because I had removed the index on these fields, makes a test and set again the index but that doesn't solved the problem.
I use Recover with the complete database and logs said "There was problems with checkup of this database. Don't use this recovered database but copy the most recent datas in an old copy."
Who is right ?
Thank you for this help. I have an empty copy of this database. I'll check this empty copy and fill if with operational datas from the one of my client.
For you RickWhitelaw,
A little drawing of my main menu page which was created in FM 7 and modifiy to run till FM14.
If bar-menu in FM15 where not so elastic, I'll use it now in FM 15. When you hide a button in a bar-menu, the other buttons grow higher or wider and the effect is not fluent.
Hope that's help you to see what I want to do.
Each customer can have its characteristic table and access what he wants. In this figure up, 4 buttons (row 2 - col 2, row 3 - col 2, row 4 - col 2 and row 4 - col 3) are hidden but exist to do other task. The statistics tap can contain from 1 to 30 buttons.