AnsweredAssumed Answered

ID lookup is not working

Question asked by VanessaAnne on Jun 18, 2015
Latest reply on Jun 19, 2015 by philmodjunk


ID lookup is not working


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?