Contract button on browse and passing a paramater

[broche]

CL 10
NT 10.06

Have a contract button on a browse that will drop down a listing of documents.
The document list is filtered on a field in the browse, there is no relationship in the dictionary between these two files.
How do I get the value from the browse to use on the filter?  I see a parameter prompt but this does not seem to work.
If I hard code the filter with the Staff ID it works just fine.

Does Not Work
'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=' &p_web.GSV('MTC:StaffSysID')

Works Fine
'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=123'

Thanks

[Bruce]

I suspect this may be one of the cases where using MTC:StaffSysID directly may be in order.
Since you are populating the parent browse, and hence cycling through the records there...
So try

'CVFA:Status=<39>ASSIGNED<39> AND CVFA:AssignedTo=' & MTC:StaffSysID

This leads me to thinking though that assigning the session value in the browse loop.

cheers
Bruce