Creating field based on text from another field

[rjay]

I have an 'Image' field that I want to contain the same data as I type into the 'Category' field with some text appended to it.

So, if 'Image' = "Jazz", I want the 'Category' field to add "http://domain.com/" to the front and ".jpg" to the end, so that it becomes

http://domain.com/jazz.jpg

I've been trying to do this with the 'Specify Calculation' option, where I entered:

"http://www.domain.com/" + CATEGORY + ".jpg"

but all I get is a '?' in that field.

[Ron Cates]

"http://www.domain.com/" & CATEGORY & ".jpg"

[Raybaudi]

Change those + to &

[rjay]

Thanks both .... obvious when you think about it :)

[LaRetta]

Just to explain a bit

& appends two strings together:

"ab" & "cd" -> "abcd"

"and" is a boolean operator:

True and False -> False

True and True -> True

+ is numerical operator