I have a multi-selection dialog list field in a form called LinkstoOtherContracts. This field uses an @DbLookup to open a view and retrieve a value into the field. All of this works perfectly.
What I would also like to incorporate into this @dblookup is the corresponding doclink AND I would like to be able to perform an extensive search within the view.
Can this be done? If so, how?
Subject: RE: DocLinks While Using @DBLookup and Views
I have a multi-selection dialog list field in a form called LinkstoOtherContracts. This field uses an @DbLookup to open a view and retrieve a value into the field. All of this works perfectly.
Is it a dialog list, or is it a computed field (if it’s a dialog list, what do you mean that your formula “retrieves a value” into the field)? Is the field editable? Is the @DbLookup to retrieve a list of choices for the computed field? What is used for a key? Does the key change while you are working with the document, and do you then retrieve a different list?
What I would also like to incorporate into this @dblookup is the corresponding doclink …
Do you want to display links to all the entries in the list you look up, or only to those the user has selected? Do you need to display the doclink in edit mode, or will it do to display in read mode only? If it must display in edit mode, would you display the same list of links the whole time you’re editing, or might it change? Is there any limit to the maximum number of links you would display at a time, or could it be any number? Would it be acceptable to establish a limit, say 5, and then if there are more things to link to, have a “more” button that displays the remaining choices in a list and lets the user select one to open?
AND I would like to be able to perform an extensive search within the view.
To allow the user to perform an extensive search within the view, tell them to open the view and use the full-text search bar to specify search criteria. If you meant that you wanted to do some kind of search automatically, perhaps you could give a little more detail about the circumstances and the type of search you want to do, and how you would like to display the results. These articles: Views Part 1 and Views Part 2: User-Based Views show how to conduct some searches and different ways to display the results. The articles cost money to read if you aren’t a subscriber, but the sample database is free.
Useful blog: Best Practice Makes Perfect
For faster answers, be C R I S P Y