-
Data retrival
Hi everyone
I have 2 tables staff details and staff deductions in access.
Now i have a form which is connected to staff deduction ( i have coded the connection). I have various fields like empno, emp name, doj etc. Some of the fields are similar with fields in tbl staff details.
Moment i type in the empno in the form connected to staff deduction i want the rest of the fields which are common in tbl staff details to be retrived and filled into the form.
Is this possible? Similar to a "dlookup" in access...
Please help..
Thanks in advance
-
Re: Data retrival
download the attachment in the in this link at post #2.
Hope its helpful :thumb: :wave: