I am using Access 2007. I have a db with 2 tables (employees, discipline).
The tables are not joined because i keep getting the error that there is a
mismatch in the data. There is a common field (employee #) in both tables. I
need to design a form that shows an employee and all the employee's
discipline. I'm really tired of going between the two tables to view
discipline on any given employee. Please assist.