Best way to implement the find Function
I have table with these fields article name, article ID and Article Color, Size.
I want to write a find function with any of the above field.
I will give one example
supposes after clicking find a user enters article color as RED and then hits return. The other 3 fields will auto populate with the corresponding data. After which if the user clicks it will continue to show other articles which has color RED. I want to be able to this with other field also like size . I just want a general way on how to do this as experimenting ways will be time consuming