Newbie - Populating parent key?
I have just two tables:
I have a layout for the Client table and it is working ok. Parent key is __ClientID That's two underscores.
I created a layout for the Employees table and can't get the parent key to populate. Parent key in this table is _ClientID. That's one underscore. In the relationship graph I have linked the two tables. In the auto-enter for the _ClientID I specified that it get looked up in the Client table.
I am getting a blank _ClientID field when I add a new record.
Can someone please help me with this before I lose all my hair. BTW, there are no fields from the Client table on the Employees layout and the table specified for the Employees layout is the Employees table.
Got it fixed.
I needed to change layouts to get the foreign key from the Client table and then save it to the Employees table. Working fine now.