jjfcpa

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?

Outcomes