ContributionsMost RecentMost LikesSolutionsRe: 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?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?