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?