Auto Enter

[Claus Lavendt]

I am a little stuck here...

In table A I have a field with AutoEnter (calculation-evaluate allways-replace existing values). It is supposed to get info from a field in table B, when ever the relation is true.

The relation is set in table B and it seems that this is the problem. The AutoEnter field in table A will not get the info.

The relation is:

Table A Table B

pk_TabelA.RecID = fk_TabelA.RecID

constantText (calc field) = Type

When I create a record in table B I set the ID from table A and Type, which match the constantText. Hereby the relation become true.

But the AutoEnter Field in table A won't get the text from the 3. field in table B.

I have created a calculated field in table A to see that the relation works. And it does work.

What am I doing wrong ?

(it needs to be an AutoEnter field so the user could edit the field)

[comment]

It won't work that way, and for a good reason: Filemaker doesn't monitor modifications in related records. See a rather lengthy discussion here:

http://fmforums.com/forum/showtopic.php?tid/172085

it needs to be an AutoEnter field so the user could edit the field

Why not place the related field directly on the layout?

[Claus Lavendt]

Like I said, it has to be auto enter.

I could easily place a calculated field or even the related field itself on the layout, but this will not enable the user to edit the content.

It is actually a lookup function, but it should refresh, whenever the related record changes.

[comment]

It's just not going to happen. You could force the editing to scripted-only, so you could set the field at the end. Perhaps there are some other options, but we'd need to know more about this than just 'Table A, Table B'.