Is there a way to "hack" an ADD page so that it has a lefthand Search panel as LIST pages do?
And can that Search panel then be set, as the Popup "LIST PAGE WITH SEARCH" to another table or query?
Over and over in my projects I have forms submitted from the Add page that must have a SEARCH panel whose values are taken from another Table of other records.
The User must perform searches of another Table's records to find the record that will match up with this particular Form.
Then selecting that matching record will Auto-fill values in the Form that is to be submitted on the Add page.
Right now the only option I have is to use the Lookup Wizard and specify a pop-up Search page to get a "List page with Search". And this action has to be attached to a field which I will use to set Auto-Fill so that a "Search page" link appears next to this field.
But the Search Page popup can only perform an "All Fields Search". I cannot isolate the field or fields I want to Search to find the matching record for the Form.
But I am using the popup Search page to drill down to the matching record.
However, once the form is Submitted the Search page disappears and must be re-started for the next form. I have a situation where one person fills in many forms in a session and this creates several extra clicks per submission.
[size="4"]Can the ADD page be manipulated so that the standard Search panel options co-exist on the Add page itself statically?
And can that search panel then be based on any other table or view?
And the result of that search be set to auto-fill fields on the Form on this Add page?[/size]
Thank you!
