I have an action button ( in database A) above my document which must only be seen by users who are listed in a list of names on a document in database B.
Whenever someone change the content of that name list it should be reflected at once in database A. Meaning that if I remove User A from that list and that user opens, right at once, a document he/she should not see that action.
I have placed a hidden field on the form that does a dblookup to database B to get the list of names. On the hidewhen of the action I show the action button if the users name is in the field.
But I have seen that that field is not allways correctly updated with the right list of names when I change the list in database B.
How can I make sure that the field will allways have the latest list of names whenever someone opens that documents and changes are made in the name list?
Subject: RE: field is not always correctly updated??
HI, Actually there is no real trigger. The field is a computed field with the dblookup as default value. I thought that whenever the document is opened the field is recalculated each time.
And what do you mean with ’ then the name should not display’ ?
it is slow. never use nocache unless you have a demonstrable problem that it fixes.
The problem you are seeing is that the computed fields are not computing quite as often as you had hoped. I suggest you don’t store the values on the document or it will use the on disk values when you open the document. Change the field to a computed for display field then resave the document to remove the on disk item. Computed for display fields will recalc on document open. If you use nocache then it will open very slowly.