Hello Kevin and thank you for using the OnBase Community!
It sounds like using an External Data Set for your Primary Keyword in an AutoFill would work for you. Using an External Data Set you can pull data from any database using a SQL Select String, VB Script, Unity Script or EIS Datasource. You can even pull values from an existing OnBase Keyword type which you can see in my example below.
You will want to create a new Keyword Type and enable the "Use Keyword Data Set" option.
In my example I am using an existing Keyword Type in OnBase that already has values, but you can use any table in any external database with a query that will look similar to what is seen below. In my example I am pulling values from the "Cascading DS > AutoFill - Primary (Source KW)" Keyword Type (#2017).
Select the new Keyword that is going to be running the external Query and click the "Data Set" button then select the "External" checkbox then click the "External" button.
Here is what your external Data Set Query will look like (For more information on External Data Sets check the System Administration Module Reference Guide around page 446).
Now create your AutoFill and make sure that the newly created Keyword with External Data set is the Primary Keyword.
When you login to the Client you can expand the Data Set to see all results or enter a partial value to filter out the results.
If you select a Primary that has a matching AutoFill record the record will expand automatically.
I hope that helps answer your question, thanks again for using the OnBase Community!
