Can anyone help?

I am trying to display an email address from a db using an Inline Action. I need it to find the Email Address where the Customer and the Site equal the values stored in two tokens.

My code below will not work and I am not sure what I am doing wrong? I think the problem area is to do with Customer={FMP-CurrentToken}, Site={FMP-CurrentToken:1}, and the way in which I have written the code.

I have hard coded the values for Customer and Site and it works prefectly. I have tried writing it like this [FMP-CurrentToken] and this [{FMP-CurrentToken}] and this "FMP-CurrentToken" and this "{FMP-CurrentToken}" but with no success!

Can anyone tell me where I am going wrong please?

[FMP-InlineAction: -db=DB.fp5, -lay=LAYOUT, Customer={FMP-CurrentToken}, Site={FMP-CurrentToken:1}, -find]

<TR>

<TD ALIGN=RIGHT VALIGN=TOP CLASS=Text10 width=50%><B>Email:&nbsp;</B></TD>

<TD ALIGN=LEFT VALIGN=TOP CLASS=Text10 width=50%><B>[FMP-Field: Email]</B></TD>

</TR>

[/FMP-InlineAction]

Can anyone tell me where I am going wrong please?

Perhaps you have misunderstood the CDML Reference database.

First it would behoove you (since you have more than one token) to follow protocol and designate your tokens Token.0, Token.1, etc.

Then notice the difference below as compared to that which you originally offered, and which includes more than just the referred protocol:

[FMP-InlineAction: -db=DB.fp5, -lay=LAYOUT, Customer="{CurrentToken:0}", Site="{CurrentToken:1}", -find]

<TR>

<TD ALIGN=RIGHT VALIGN=TOP CLASS=Text10 width=50%><B>Email:&nbsp;</B></TD>

<TD ALIGN=LEFT VALIGN=TOP CLASS=Text10 width=50%><B>[FMP-Field: Email]</B></TD>

</TR>

[/FMP-InlineAction]

This, of course, assumes that, in addition to following the protocol referred to, the fields Customer and Site are on layout LAYOUT.

(Edited code: from Customer="{CurrentToken.0}" to Customer="{CurrentToken:0}" - sorry for my sloppiness.)