Creating One Relationship Field From Two Existing Calc Fields

[J. Williams]

Not sure I'm posting in the right place, so feel free to move me around...

I'm trying to create one field, from two calc fields, inclusive of an "." in between, for the purposes of creating a realtionship with another FM database.

As an example, independently I have:

03

12345

What I need in order to create the relationship is:

03.12345

I'm sure it's simple, but for the life of me can't get it figured out!

Any assistance would be greatly appreciated!

[J. Williams]

Oh heck, got it.

Field & "." & Field

Sorry to waste your time, can't believe I blanked on it... then panicked so quickly.

[mr_vodka]

I am not sure if I am answering your question correctly but you could just do a simple concat of the two field. FieldA & "." & FieldB