Pulling in data from another text box

[johncassell]

Hi There,

I have a form with all the fields from my 'Jobs' table including a textbox called 'CustomerCode'.

I then have one text box from my 'Customers' table called 'CustomerName'.

They have a relation and I dragged the CustomerName field from the child customers table onto my form.

When my jobstableadapter is filled, the customercode is there and it also shows the correct CustomerName. However, when I change the customercode, the customername stays the same.

What is the best way to achieve this? I have tried to create a fillyby query on the customers table to be activated when the user changes the customercode box but all this does is leave both boxes blank when a job loads..

Would appreciate any help

Thanks

John