Listers, Posting again - there was an error in my earlier post + added more details.
------ I have come across an issue, possibly a bug. I have a filter on a regular form that is doing a set fields action The set fields is doing a lookup from a join form to bring the values The Set Fields If (earlier post had Run If) qualification looks something like this: ('Instance ID' = $Instance ID$ AND (EXTERNAL ($External Qual$)) The $External Qual$ value is based on user preference settings and cannot be modified. The fields used in the $External Qual$ are referencing the Join Form. The option to change the field types on any of the forms does not exist. As an example the 'External Qual' field has the value: ('Status' = "Assigned" AND 'Work Log Type' != "General Information") -- 'Status' is a selection field and coming from the primary form that makes up the join -- 'Work Log Type' is a selection field and coming from the secondary form that makes up the join. When the qualification has a selection field that is coming from the primary form that makes up the join, then the set fields behaves as expected, bringing the values back that match the Set Fields If qualification However, when the qualification has a selection field that is coming from the secondary form that makes up the join, then the set fields behaves as though that selection field part of the qualification does not even exist. Not sure any of you have come across this issue and if there is a workaround or another way to overcome this issue. Any suggestions/input is valuable Here's the environment details: AR Server 7.1.0 Patch 6 on Linux Oracle 10g R3 on Linux ITSM 7.0.1 Patch 9 Thanks in advance, -- Shyam _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"