I have a layout which is a stock list for my inventory. It lists all my machines and sorts them by sub-summaries of Category and Colour as follows:
What I need to do is create a search form, which is a different layout that only has a list of certain fields (such as Category, Colour, and the other machine data found on the stocklist). Users can then enter their queries into this simple form, and when they press submit, it automatically creates a stock list based on their requirements. For example if they search for a specific category (i.e. Sheet Fed), the resulting stock list will only show machines of that category (still sorted in the original manner).
Please advise how this can be accomplished. Thanks.