I want to have filemaker generate and alphanumeric sku# by combining the contents (or first few characters of the contents) of one field with the contents of a serial number field. IE:

first field = elephant

serial field = 420

sku field = elephant420

or

sku field = eleph420

Thanx 4 Your Help!

Make the sku field a text calculated field with the following formula:

sku Field = first field & serial field

or if you just want the first few characters of the first field (6 for example) then do this:

sku field = Left(first field,6) & serial field

Wow!!! Thats even simpler than I thought!! Thanx 4 the speedy Reply

Just wondering if anyone got this to work? I am having a heck of atime with this calculation. Please assist.

nW

Is your calculation defined to return text or number?

This is the way that i do it.

SkuField = Left( FirstField , 5 ) & NumToText( SerialField )

Make sure the calculation result is text.