Insert Calculated Result in IWP (Find mode)

[whitemyer]

I've searched the forum and can't find an answer to my question. So hopefully someone out there can shed some light...

In my photo archives database (published via IWP), I want my clients to be able to search their photos, but I don't ever want them to see other clients' photos. The "Home" layout is always viewed in Browse mode. The only visable field on it is a global field that is set to "" every time someone goes home.

The idea is that the user enters the search term in this field, then clicks the Search button. This button is scripted to copy the contents of my global search field, enter find mode, paste into a Keyword Concatenate field (which is on the layout, but pretty well hidden from the users view), then insert the calculated value Users::Company (from the Users table, which is related if Get(AccountName)=Username) into the Client field (which is a text field in the current table and hidden away in my layout). Finally, the script performs the find, goes to another layout, sorts, etc. Where it appears to be hanging up is when I try to insert the caluclated value. It works in FM, but not in IWP.

I've tried to find workarounds - dump Users::Company into a global field and insert from there, copy Users::Company and paste into Company, then insert the Global Search contents into the Keyword Concatenate field, etc. But it just seems that IWP doesn't want to insert any calculated result into a field in find mode.

Anyone have any suggestions?

PS - FM 7.0.3, Mac OS X 10.3.6 if it helps.

[whitemyer]

I've found a (somewhat cumbersome) workaround for this. The script now copies the contents of Users::Company, enters find mode, pastes into Client, and performs the find. Then it copies the contents of Global Search, modifies the last find, pastes into Keyword Concatenate and performs the find again. Seems like there ought to be an easier way. If anyone knows of anything, please let me know. I'm probably going to end up using this functionality on several projects, so I wouldn't mind an easier, softer way.

Thanks!