Forum Discussion

JasonPhenicie's avatar
JasonPhenicie
Qrew Trainee
10 years ago

Can I have my collaborators dropdown (comes from another table) in my projects form only show ones matching the specified department and don't have inactive checked?

My collaborators table has all of the information about our "clients," including a checkbox to mark them inactive. Our projects form has two dropdowns... the first is for department (user selects fir...
Forms
Relationships
roles and permissions
AaronCarroll's avatar
AaronCarroll
Qrew Member
9 years ago
Lets say you have a "Job" Table and a "Job's Detail" Table.  The Job has the main data of the job, address etc..  Then the Jobs Details has line item details (Billables). There is a JobNumber on both tables.  Can I have a drop down on the "Jobs Detail" table from the "Jobs" table where field "Status" is active and pull only active Job Numbers?