Field Association

[sam2601]

Hi guys,

I have a form with a drop down Department Type and a Cost center editable field.
User will type cost center and drop down will have show the associated Department Types
for that cost centers.

Is there any way i can do it.

I have lotus domino designer 5.0.

Any ideas ...Pls advice..Appreciate it!!!

Thanks

 

[pmonett]

Seems feasable. I suppose your departments are all defined in relation with a cost center.
Specifically, I suppose that on every Department doc, there is a field with the cost center it is related to.
In this case, make a view where the first column lists cost centers, and the second lists departments. Sort both columns.
Your drop down field can now use a @dblookup on the cost center criteria, and return the second column.
For this to work correctly, you need to set the cost center field to "refresh fields on change", and the drop-down to "refresh choices on document refresh".

Hope this helps.

Pascal.

 

[sam2601]

Thanks Pascal,

I did it as you suggested it works only in Lotus Notes Preview not in Internet Explorer.Is there any way i can make it work in other browsers too.

Thanks and appreciate it!!!

 

[pmonett]

In a browser you have to save the document to get the refresh. This is a browser issue - browsers are dumb clients and cannot offer the same level of functionality than in a full client. In any case that is the only solution I have ever found.

Pascal.

 

[sam2601]

Thanks Pascal,

I got it to work.What i am doing is refreshing the page onChange event of the text field.It works!!!

Appreciate getting back!!!

Thanks

 

[pmonett]

OnChange ? Hmm. I'll have to look into that. You put some Java in there, I guess ?

Pascal.

 

[sam2601]

Yes , I wrote some javascript to refresh the page.It works fine!!!.