I have an inventory table, ID, make, model, description etc. I would like to display this table (I assume in a layout) as read-only, not changing any data but when a user clicks in a field that field becomes a search field, upon entering say a model number, the view refreshes to show any matching records grouped together and still show all the records within the table. In other words not show JUST the searched records but group the results and still show the surrounding records. I may be out of my mind here but I can't seem to see a way to do it.
Thank you in advance