Going to give this a try, thank you!

I want to create a form with a dropdown list of locations, a required field.We already have a database that contains a list of store locations and their associated brands that is updated as we get new locations or brands change.It would be great if we could fill that location field with a query from this database. I have the php/mysql knowledge to make the query, but have no idea how to implement it into the list or field.What is the best way to accomplish this?

I have a question on how best to setup osTicket up for our situation - an internal marketing departmentWe have 30 locations covering 10 brands over 5 regions/platforms, with 4 coordinators that are responsible for different sets of locations. When a ticket comes in it gets routed to the specific coordinator based on the location it is for (or the specific email address of the person submitting it). After all requirements are vetted out with the client who submitted the ticket, or with a designer brainstorm session, the coordinator distributes tasks to the teams - usually the design team create the digital assets for approval, and then they often go simultaneously to both prepress and web dev teams.The fun/annoying/problematic issue - some projects are for a single store, some projects are for a brand (with multiple stores across multiple regions) and some are for a whole region/platform (which covers multiple brands and stores)..How would you set up osTicket to maximize workflow for tickets? Would I set up the coordinators as teams or groups? Can a ticket be viewable by 2 teams at once, or would I need a list (can lists have multiples chosen?) I'm assuming that brands and regions/platforms would be custom lists, but please advise me if I'm wrong!