Lookup function question
I use a calculation: Case ( Lookup (DESIGNATED_SUB::DESSUB_SH )= SUB1_DATA::SUB1_ShNm or Lookup (DESIGNATED_SUB 2::DESSUB2_SH)= SUB1_DATA::SUB1_ShNm ; "*" ) and have noticed something interesting. In the table DESIGNATED_SUB I have an auto-enter date field set to enter Modification Date. If I go back in time in the "parent" table and re-initiate the lookup by either changing the record or deleting and re-entering it, if the date of the "parent" record ( a simple date field) is before the Modification Date already mentioned in the child table, "*" is not returned. There are obvious advantages and disadvantages to this. What puzzles me is that I can't find any documentation on the issue. The lookup function (in a calculation) allows indexing of a calculation field but I kind of expect the function to behave as a "standard" lookup does. . . meaning looking up the value at the time of data entry. Any thoughts appreciated!