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