2 Replies Latest reply on Jun 19, 2015 7:09 AM by philmodjunk

    ID lookup is not working

    VanessaAnne

      Title

      ID lookup is not working

      Post

      I'm creating a call log database.  I have Two Tables:  1 - Call Log Table where I keep track of calls.  2 - Contacts Table where I store all my contact info.  Each table has a _callerID field for a unique number.  

      The Contacts database has a _CallerID field that is an automated serial number upon creation. The Call Log table has a unique field as well of a _callerID number that looks up to the Contacts Table's serial ID number. A relationship has been created for this.   

      When I create a new record in my Call Log layout, and enter into a name that is fed from my Contacts table using the drop down value list pulling from a related field (and auto-entered), the serial number in _CallerID layout does not get populated. 

      I want to be able to put in a name and have the data from the Contacts table auto populate. This isn't working either but I suspect it is because of the serial ID error. 

      What am I missing?