Dear Paul,

Hope you can spare some of your time to point me in the right direction?

Basically I want to select on multiple keys from the

Edit Selections

Select Statement:

Something like:

select KeyOneID,KeyTwoID,DataField

from myTable where KeyOneID = [EDIT:V:0]

and KeyTwoID = [EDIT:V:1]

EDIT columns from a selection grid can quite easily be placed in

Edit Selections

Header Message:

Key - [Edit:V:0],[Edit:V:1]

And will be correctly displayed as values on the top of the edit/delete page.

Equally multiple values work in the

Delete Statement:

e.g.

exec dbo.procDelete [Edit:V:0],[Edit:V:1]

Naturally I then tried a proc in Edit Selections as per

exec dbo.procLoadByKey [Edit:V:0],[Edit:V:1]

but again no luck.

although procs (and selects) do work with KeyValue as in:

exec dbo.procLoadByKey [Edit:V:0],[Edit:V:1]

or

select KeyOneID,KeyTwoID,DataField

from myTable where KeyOneID = [EDIT:KeyValue]

Bit stuck on this one so I would very much appreciate any assistance. I have got a feeling that I may have missed something so obvious I can no longer see it!

Thanks for this module it is becoming very usual especially when you factor in JScript to the EDIT Template and populate it cleverly with the correct TSQL.

Cheers,

Ashley