I created a self relationship based on my Record_ID (auto enter serial number). I want my lookups to be based off this self relationship and lookup calculations that I created in the same database. It works great for records already in the db as I just do a relookup. However, when entering new records, these lookups do not behave the same as lookups from outside the db, the lookup remains blank unless I do a relookup. I don't understand why it doesn't populate automatically since I am generating a new Record_ID and the lookup is based on this relationship. What am I doing wrong?

A lookup is triggered when the value of the key field on which the lookup is based is entered or changed. When you create a new record the Record_ID is entered when the record is created and before any other data is entered. To lookup data from this record the lookups based upon the Record_ID must be triggered again with a relookup.

-bd