I have created an action that adds a record to another table passing the FID (PrimaryKey) and the clientid stored on a session variable but it does not seem to work. this is the sql code:

insert into ClientForms
(CID, FID)
Values ($(DSSession1), $(PrimaryKey))

if I use the following sql then the sql action works fine.

insert into ClientForms
(CID, FID)
Values (22, $(PrimaryKey))

Is there a way to make this work with Dynamic Views?