July 3, 200817 yr 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)
July 3, 200817 yr 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?
July 3, 200817 yr Author 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.
July 3, 200817 yr 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'.
Create an account or sign in to comment