I want to be able to within an object select using a lookup a Project, then in a second attribute lookup select the Task but only want the Tasks that are part of the Project selected in the previous attribute to show as available options.
Have you checked this ?
This is useful, but this is different than what I'm looking for at the moment. I want the only option to be the tasks, which would not be singular unless I'm not reading enough into it.
Check this -
And this -
I guess this is where I'm lost, I saw the post about Project and Task...
This is my Project Lookup:
@SELECT:(INV.NAME||' ( '||INV.CODE||' )'):DISPLAY@,
INV_INVESTMENTS INV, INV_PROJECTS PRJ
AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)
This is my Task Lookup:
SELECT @SELECT:TASK.PRID:Task_ID@,@SELECT:(TASK.PRNAME||' ( '||TASK.PREXTERNALID||' )'):DISPLAY@,@SELECT:TASK.PRPROJECTID:WE_ID@,@SELECT:INV.CODE:WE_ENum@,@SELECT:INV.NAME:WE_Name@,@SELECT:TASK.PRNAME:Task_Name@,@SELECT:TASK.PREXTERNALID:TaskID@ FROM PRTASK TASKJOIN INV_INVESTMENTS INV ON TASK.PRPROJECTID=INV.ID
I'm just not certain how to embed the Project within the Task lookup.
In the TASK lookup - in the QUERY screen you should see the "To create a dependent lookup, enclose the lookup internal name in "@" symbols." text.
So that would be where you put the name of the project lookup.
I can't quite recall (from memory) what that then enables (options in the Lookup Filters tab?), but that should get you started...
Retrieving data ...