Concatenation in Macro

[trc_pdx]

I'd like to populate the value of a field on a form based on the concatenation of the values in two other fields. Thought I might be able to define a macro that concatenates the two other placeholders. If this is possible I haven't stumbled onto the right syntax. Any ideas? Thanks!

[eliaslynch]

going off of memory, but isn't syntax like this?

Code: Select all

%[Assignee_ID].[Last_Name]%+ ', ' +%[Assignee_ID].[First_Name]%

doesn't that work? I see macros support full SQL queries now so can't imagine it won't work.