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

Hi sorry everyone, I have just seen the additional drop down field below the table in form view that I should of dragged onto the form which then gave me the selected field I wanted.