I have a form based on one table. In the table that the form is based on I have two columns called column 1 and 2 and these both have data in them.
On the form I have two text boxes, textbox 1 and textbox 2. If a user enters a number like 123456 into textbox 1 (and this same number is within column 1 in the table, I would like textbox 2 to automatically populate with the corresponding reference that is within column 2 in the table (i.e. next to the relevant number in column 1).
Is this possible?