Page 1 of 1

FIELD AUTO ENTRY CALCULATION QUESTION

PostPosted: Sat Jan 07, 2006 6:35 pm
by Guest
Hello,
I'm using the auto-entry calculation option to populate a field based on the contents of a field in a related table. However, the calculation seems to completely ignore all references to fields outside the table the auto entry field is in. Is this a bug or could I be doing something wrong?
Any help would be greatly appreciated.

PostPosted: Tue Apr 11, 2006 1:18 pm
by bkmcse
Double check your relationship. Also look to see if "Allow creation of records in this table via this relationship is checked.

PostPosted: Tue Apr 11, 2006 1:30 pm
by John Sindelar
Sometimes you have to play with these things to get them to work. For example, your field might not know that the related value has changed. In such cases, you may need to "force" the auto enter to evaluate by including extraneous fields that will be often and reliably changing. You can also checkout the syntax for the Evaluate function which lets you explicitly include fields to watch for changes. At the end of the day, if the data that's changing is very far away, you may need to move it or run some scripts to refresh the auto enter.