<<Hello Robert,

> How cani join two fields together
> like FIRSTNAME + LASTNAME = FIRSTLAST

By using the standard operator for string concatenation:

FIRSTNAME || LASTNAME >>

And, assuming you want a space between them:

FIRSTNAME || ' ' || LASTNAME

Clay Shannon,
Dimension 4 Software