When I am putting PDF documents and rows from a table into the same index, I create "dataSource" field to identify the source and I don't copy database fields - only index them - apart from the unique key which is stored as "document". On search, you process the output before passing to user. If datasource is pdfs etc, then you should have highlighted text to pass on. If dataSource is the table, then fetch the rows from database and display the search fields as "highlights". A lot of postprocessing of search results but easier to create meaningful results if a single row in the table contains what a user wants. You need a custom indexer and a custom results postprocesser however. Notice: This email and any attachments are confidential and may not be used, published or redistributed without the prior written consent of the Institute of Geological and Nuclear Sciences Limited (GNS Science). If received in error please destroy and immediately notify GNS Science. Do not copy or disclose the contents.