In my experience it has always been undependable to autoenter by calc through a relationship, even one generation away. try putting the values into globals and autoenter by calc = global
Well that's depressing, since this is in principle a useful aspects of the Auto Enter feature. Can the Filemaker tech support team comment on this problem, which must be a very widespread problem if your comment is correct?
To add the information the moderator has requested for bug reports:
OS: Mac 10.5.5
Filemaker Pro Advanced: 9.03
Thank you for your post.
This is a limitation of our current form-based submission model. The problem is that the field is set for modifiable, and its value is updated when the form submission occurs. If you mark the field to be non-modifiable during data entry, then it gets updated correctly. Another workaround (although I've had difficulty with this one) is to place the auto-enter field at the back of the stacking order. When form submission occurs, the fields are updated from back to front. Only fields where the submitted value is different from the existing value are changed.
The workaround by "gaBby" also works (Thank you!).