What is the best way to allow a user to run a search query from a drop down menu?
Basic Project information fields (Project Name, Date, Location, Producer, Editor, Talent, Status and so on)
Search Button: turns all fields on the layout into a searchable field.
Project Load Drop Down Menu
This Does not work yet.......
I would like the drop down menu box to be loaded with all of the project name records from the project table.
When the user selects the project he wants to work with, they would click on the load project button, then the layout would be refreshed with all of the fields from that particular project.
How do I make this work?
Thanks for the help ahead of time!