Newbie - Getting parent key to populate in child table?

Discussion created by jjfcpa on Oct 27, 2012
Latest reply on Oct 28, 2012 by jjfcpa

I have just two tables.


Client and Employees


Client has a parent key - __ClientID


Employees has a parent key - __EmployeeID and a foreign key - _ClientID


I have an Employees layout that I use to add new employees and whenever I add a new employee I'm not getting the foreign key populated. What is the proper way to make this happen?


Right now, I'm just clicking the New Record button to add a new record. I am not using a portal. I believe I have the relationship graph setup properly. I have a one to many relationship between the Client and the Employees. I've tried to use the auto-enter properties of the _ClientID field to populate it with the __ClientID field in the Client table, but it still ends up blank.


Not really sure what I'm doing wrong?