I have an app for tracking company vehicle usage by department. What I would like to do is set it up so that depending on the department selected in the first field, only certain vehicles appear in the second field. For example, if someone from Sales wants to check out a vehicle, the Sales department is selected, and only cars available for the Sales team appear as options.
Make a Relationship where 1 Dept has Many Vehicles and populate your Vehicles table. Maybe you already have that in place.
On your usage Table you probably already have a drop down for [Related Dept] ideally with a Proxy field Of [Dept Name].
Your usage table will also have a field to select [Related Vehicle]. Set the field Properites in that field such that it's Conditionsl, with the condition that after [Related Department] is selected only display choices where it matches the value on the Vehicles table for [Related Department].
I have a table PROJECTS and an relationship where 1 PROJECT has many TASKS.
From a SEPARATE table, I want a user to chose only TASKS related to the PROJECT they chose first... basically same idea as above.
I am just having trouble with the [Related Task] field... I think I am missing a step somewhere. I have two relationships to the SEPARATE table... one project has many job records and one task has many job records... I can't figure out the conditional field... what type of field is this? How to add it? It seems that whatever type of field I try to add does not have the conditional options...
Thanks in advance for any insight.
1 Project has many Tasks - that sounds normal.
1 Task has many Jobs - that sounds normal - as it looks like what you call a Job is like a Sub-task.
So why do you need a direct relationship such that 1 Project has many Jobs? if you want to have a list of Jobs on the Project record, just make a Report Link field on the Project record - you do not need to have a Relationship to make a Report Link field. If you need any fields from the Project record down on the Jobs record, just pull then though a double hop lookup to the Task record and then from there to the Jobs record.