Link to home
Start Free TrialLog in
Avatar of ITDharam
ITDharamFlag for United States of America

asked on

Moving attachments within document

I have a database where there are sometimes 10 attachments attached to a document.  I'd like to secure access to those attachments by restricting based on userroles.

In order to do that I believe I need to move those attachments to a richtext field in order to take advantage of the 'hide when' feature.

What is the best way to move all of those attachments to a field within the same document when it appears that they were originall attached to the 'body'.

Thanks,
Avatar of marilyng
marilyng

You cannot use the hide-when features in a rich-text field, they are unpredictable.

Instead use subforms, one with the rich text field and the attachments, and one without, or one rich text field per attachment and add or remove subforms.. although the robustness decreases with more subforms (each is an additional hit on the server)

The subforms can be computed, so when someone of a certain role opens the document, the rich text subform shows, else it doesn't.

Downside is that refreshing the form doesn't change the subforms, so if someone opens in read mode and switches to edit mode, you have to close and reopen the form to get the subform to load.
ASKER CERTIFIED SOLUTION
Avatar of cezarF
cezarF
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial