Search and Results are working!
Yes I have it working with Search & Results page:
I now want these to be dynamic as discussed using Dyanmic Dropdown - filtering the list per dropdown selection. I am unsure on how to create the relationship between these tables. Would I need any extra fields in these tables (I had attached the database on post earlier). What are my next steps?