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?