We have an existing set of queries (all working) but the client requests several others.)
1. Client initiated form-input-based search using 1 text box but allows at least 2 possible parameters that relate to 2 separate tables. One parameter will likely require wildcard possibility.
2. Search result join must be implimented and the (new) table must be set up to automatically key to the (parent) table.