AnsweredAssumed Answered

ID lookup is not working

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

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? 

 

Outcomes