Hi, I have searched the forums but not found exactly what I am needing. I am new to the system so apologize for my newbee question.
I have created two tables. In one it has the field { employee involved }. I have dragged the other table into the foreign field section as described in the instructions.
The other table has - the auto id, employee name, date started , position and employee type.
When I go and have a look the other table when on a form seems to auto connect to the ID field which I cannot see when building. I want it to select from the employee name field but there seems to be no way in the component creator to be able to do this. I am not a coder so have no idea what to do to make this happen.
Any assistance would be greatly appreciated. And again, sorry if this is covered somewhere else.
Regards
Jonathan
