On Thu, 29 Oct 2009 15:11:01 -0700, dls61721
wrote:
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.
Please post a description of your tables: fieldnames, datatypes, and whether
the field is a Lookup Field (it shouldn't be, see
http://www.mvps.org/access/lookupfields.htm for a critique of this
misfeature).
If each employee can be in several disciplines and each discipline can be
practiced by several employees, you need another table with the Employee# and
the DisciplineID.
--
John W. Vinson [MVP]