G
Guest
I am trying to create a form from mutltiple tables (2
tables) so that it displays the persons name from employee
details table on entering the employee ID number in the
form. However no details are displayed when I enter the ID
number (this is the link field between the 2 tables).
As I understand it, when I enter the employee ID on the
form and it matches an existing ID in the employee table
the name should be displayed immediately. This does not
happen. However, if I close the form and open it again,
the form has been updated and the name is displayed, thus
implying the relationship and the process is correct.
Why does the data not display immediately on matching the
ID numbers? Does anyone know??
tables) so that it displays the persons name from employee
details table on entering the employee ID number in the
form. However no details are displayed when I enter the ID
number (this is the link field between the 2 tables).
As I understand it, when I enter the employee ID on the
form and it matches an existing ID in the employee table
the name should be displayed immediately. This does not
happen. However, if I close the form and open it again,
the form has been updated and the name is displayed, thus
implying the relationship and the process is correct.
Why does the data not display immediately on matching the
ID numbers? Does anyone know??