I have a database with information in it regarding jobs that employees are performing. They frequently need to update their records as items on a particular job# are completed. What I would like to do is prompt the user for their EmployeeID and ONLY display those records in a form/popup/etc and then have them select one of their own records from the list that was just displayed, then bring up the full form for that selected record for updating/editing.
This should be possible, correct? There are currently two tables, employees and jobs, employees has EmployeeID and EmployeeName and the jobs table has all of the job information plus EmployeeID.
Any information would be greatly appreciated.
Thank you in advance!