How do Microsoft Access queries translate in Zoho Creator? The limited knowledge I have about databases and applications comes from working with Access so the only way I know how to ask the following question is by referencing Access queries.

I have two forms: one that holds a record of every job my company has ever worked on. It is essentially a jobs database that has a field that displays the status- active, completed, incoming, etc. The other form is an internal work order request for any of those jobs. On my internal work order request form there is a lookup function so that anytime you generate a work order request you have to select which job it is for in a drop down list. Is it possible to get the drop down list to only display jobs that have an "active" status rather than every single job in the database? In Microsoft Access I think I would run the lookup function on a query that displays the "active" status.