I have a database that has three fields relating to customer details, what i want to do is create an input form where when i enter from the "spec Number" it automatically enters data into the field "customer" and the field "cust ref". Can someone tell me how to do this please. Example of data below
spec No customer cust ref
KT63798 KETTLE RM001762
KT63799 KETTLE RM001796
KT63800 KETTLE RM001765
KT63803 KETTLE RM001769
KT63804 KETTLE RM001775
KT63805 KETTLE RM001797
Regards
Paul
spec No customer cust ref
KT63798 KETTLE RM001762
KT63799 KETTLE RM001796
KT63800 KETTLE RM001765
KT63803 KETTLE RM001769
KT63804 KETTLE RM001775
KT63805 KETTLE RM001797
Regards
Paul