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.
FIELD AUTO ENTRY CALCULATION QUESTION
3 posts
• Page 1 of 1
|
|
Posts: 3
Joined: Tue Apr 11, 2006 1:06 pm |
Double check your relationship. Also look to see if "Allow creation of records in this table via this relationship is checked.
|
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am |
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.
John Sindelar
SeedCode |
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 4 guests