I have a question about a form/table setup.
Table layout is as follows:
tblEmployee
ID
FirstName
LastName
HireDate
departmentID
tblDepartment
ID
Department
The relationship is a one (tblDepartment) to many (tblEmployee)
for the life of me I can't remember how I'd go about showing the Name of the department on a bound form rather than the department ID.
I tried making a query, and basing my form on that query, but if I needed to change the employee's department, I ended up changing the actual department name on the department table and not the departmentID on the employee table.
I was thinking of using some trickery via VBA with DLookup. but thought that there must be an easier solution that I just can't remember.
It's been a few years since I've done any Access work, moved on to SQL and VB.net for the most part.
Table layout is as follows:
tblEmployee
ID
FirstName
LastName
HireDate
departmentID
tblDepartment
ID
Department
The relationship is a one (tblDepartment) to many (tblEmployee)
for the life of me I can't remember how I'd go about showing the Name of the department on a bound form rather than the department ID.
I tried making a query, and basing my form on that query, but if I needed to change the employee's department, I ended up changing the actual department name on the department table and not the departmentID on the employee table.
I was thinking of using some trickery via VBA with DLookup. but thought that there must be an easier solution that I just can't remember.
It's been a few years since I've done any Access work, moved on to SQL and VB.net for the most part.