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.

Thoughts?

Have you checked this ?

TIP : How To Put Any Dynamically Generated Value On A Clarity Object

NJ

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 -

Dynamic Dependent Lookups at portlet level

And this -

Help To Build Dynamic Query

NJ

I guess this is where I'm lost, I saw the post about Project and Task...

This is my Project Lookup:

SELECT

@SELECT:INV.ID:ID@,

@SELECT:(INV.NAME||' ( '||INV.CODE||' )'):DISPLAY@,

@SELECT:INV.CODE:CODE@,

@SELECT:INV.CODE:UNIQUE_CODE@,

@SELECT:INV.NAME:NAME@

FROM

INV_INVESTMENTS INV, INV_PROJECTS PRJ

WHERE

@WHERE:SECURITY:PROJECT:INV.ID@

   AND INV.ID=PRJ.PRID

   AND PRJ.IS_TEMPLATE=0

   AND (INV.PURGE_FLAG=0 OR INV.PURGE_FLAG IS NULL)

   AND

@FILTER@

@BROWSE-ONLY:AND INV.is_active=1:BROWSE-ONLY@

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 TASK
JOIN INV_INVESTMENTS INV ON TASK.PRPROJECTID=INV.ID

WHERE @FILTER@

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...