Diplaying Calc/Summary Fields in Find Mode

[Greg Hains]

Hi,

I have a page with a number of fields that display summary of database data - eg calculated values. It displays the information as I want, but I have to do a Find from this page as well, and when I go into Find mode the values/text disappears. How can I make the values stay there whilst in Find mode?

I have tried playing with the field behaviour and entering Browse Mode, Find Mode etc but it makes no difference.

Any tips please.

Ta.

Greg

[Genx]

Hi Greg,

Unfortunately calc's and summary's won't function in find mode as they are looking at entirely different data -- e.g. you are looking at "find records" as opposed to standard records - whether or not a summary field will actually summarize the current find requests as it would with standard records is something i might look at

... but to answer your question

If you want to present this information to the user in find mode, your best bet is to transfer the data to a global field before entering find mode - globals are global throughout the database, and throughout window modes (i.e. find vs. Browse vs. Layout) so any value you enter into it will persist. But to do this, you'll probably want to use another layout so that the globals - which are updated only when you set them to a value - will be displayed only immediately after they are set.

i.e. Script -> Set Globals to current summary / calc values -> go to search layouts where you have your globals instead of your summary fields -> have the user search -> return the user to the original layout with the live state summaries and calcs.

I'm in one of my confused moods atm when i'm not very good at explaining things, but I HTH.

Cheers.

[Greg Hains]

GenX to the rescue again.

Thanks, I'll explore this angle.

Greg

[Genx]

Lol to the rescue eh?

Glad to help, let me know how you get on.