I currently have a search results Report that displays information from individual records. When someone searches by typing in a description of a record for example the report would show:
Records with related descriptions in a textbox - "Description"
also fields that go along with that related record such as
plan number, file location, physical description
Due to a large amount of records within the database and to make it easier then scrolling through large amounts of records once clients type their search criteria in, I want to have a button beside the record that opens another report that has more fields associated with the record