April 19th, 2016, 10:15 AM
Join Date: Apr 2016
Time spent in forums: 14 m 52 sec
Reputation Power: 0
Auto populating a Query with a Form
Thanks for the opportunity to ask this question. Please I am now learning access DB so pardon me if my question is fundamental.
I have 2 tbls as follows:
DEPT (TBL 1)
d_DeptID (autonumber) - PK
EMPLOYEE (TBL 2)
e_EmpID (autonumber) - PK
e_DeptID (number) - FK
From these tables, I have the query below:
I have created a form and now my problem is that I want to be able to auto populate the e_DeptID field from the DEPT (TBL 1) the using this Data Entry Form. Because allowing a user to enter such a key field can cause a disaster.
Assistance from anyone will be greatly appreciated.