Refering to field when creating table relationship using string

[Miles R]

I'm sure this must be simple, but can't find the correct syntax to make this work.

I have the following code :
relRelation.Fields!Place.ForeignName = "PlaceFirstlogged", where relRelation is a relation set using CreateRelation



I want to replace this with :
relRelation.Fields!strTableField.ForeignName = strForeignTableField where strTableField is a string referring to the main table field and strForeignTableField is a string referring to the Foreign table field.

This gives an error on the first bit relRelation.Fields!strTableField.ForeignName - it says "Item not found in this collection"

What is the correct syntax to make this work?

[Welshgasman]

Perhaps

relRelation.Fields!(strTableField).ForeignName

or

relRelation.Fields.(strTableField).ForeignName

[CJ_London]

Or perhaps

relRelation.Fields(strTableField).ForeignName

[Miles R]

Thanks for the reply, but I've tried both those. Both fail at compile time.
The first gives : Type-declaration character does not match declared data type
and the second just gives a syntax error.

You see my problem in finding the right syntax.

[Miles R]

Wow, yes that works.
Knew it would be simple, problem solved.

just to be clear, that is relRelation.Fields(strTableField).ForeignName posted by CJ_London

[Welshgasman]

Wow, yes that works.
Knew it would be simple, problem solved.

just to be clear, that is relRelation.Fields(strTableField).ForeignName posted by CJ_London

Well I was close?