I want to take the input of the Plot Owner's First and/or Last Name, or a combination of the names LIKE ownerLast = "l" ownerFirst = "" and return the information from the owners table into a dropdown box all plot owners with that criteria. Basically I want this to be a search within a search, searching the Owners table for Like owners and then populating a dropdown box with those possibilities ( there can be a submit button that does a hidden search to populate the dropdown box as long as the page reloads with the previously entered information.
Is this possible to do or would it require something like JavaScript in order to do it? I am assuming also that I will need Sessions to keep the previously entered info in the other boxes and I don't have any of those on this page that would do that ... yet.
I need to find the owner ID from the owners table of the names that they enter and I am not sure how else to accomplish this.
I know that I can do a query on the owners table using LIKE statements but how would I get the information to show on the search form?
Hope this makes sense. Ask for clarification if you need it.
