Form 1 has all the regular information for employees.
Form 2 has the dates of their "progress reports" for each year (you'll have multiple records for a single employee on Form 1)
Form 2 is also a popup (just a small window with a few date fields and a record selector so you can scroll through the multiple progress reports for that employee)
I guess what i need to do is filter form 2 depending on Form 1. The two forms 'frm HR Employees' and 'frm HR Prof' are linked together by their 'EmployeeID' within their respective tables: 'tbl Employee' and 'tbl prof'. The form 'frm HR Prof' is opened through a link on the main form 'frmHR Employees'
I've done this before, I just don't use Access enough to rememeber all these little tricks.
Form 2 has the dates of their "progress reports" for each year (you'll have multiple records for a single employee on Form 1)
Form 2 is also a popup (just a small window with a few date fields and a record selector so you can scroll through the multiple progress reports for that employee)
I guess what i need to do is filter form 2 depending on Form 1. The two forms 'frm HR Employees' and 'frm HR Prof' are linked together by their 'EmployeeID' within their respective tables: 'tbl Employee' and 'tbl prof'. The form 'frm HR Prof' is opened through a link on the main form 'frmHR Employees'
I've done this before, I just don't use Access enough to rememeber all these little tricks.