how to display a calculation result in text box without selections.

[fashid]

Hi,

I have an application which has section access on the branch names.

I have created an expression which gives the rank of the branch .

Say now when a user logs on . he has access to only a particular branch. so the text box should display that branch's rank.

But the problem i am facing is that ,the text box only displays the correct rank when the user makes a selection in the list box .

How do i get the text box to display the rank without the user making selection.

I am attaching the sample app that i am working on .

Regards,

Nadeem

Message was edited by: nadeem shaikh

[datanibbler]

Hi,

okay. If the issue is just selecting both possible values - in your case, that is rather easy - you want to simultaneously select all the possible values for that user, right?

=> In that case, just use the *

I don't know how you could select > several, but not all < possible values, but that too must be possible.

HTH

[fashid]

To calculate rankings in the load script is very difficult in my case as it is not just a simple column in the source field against which i am calculating the ranks .

[fashid]

Can i select values in a calculated list box based on a trigger.

I mean when i am creating a trigger i have list box which is based on an expression which is not actually a field.

So can i make selections on that

[fashid · Accepted solution]

Hi,

So what i did was, I created a trigger on open to select the value in the field and that did the trick for me .

Now the text box displays the desired result.

Regards,

Nadeem