Form Design
First make sure the [employee #] field in both tables is the same data type.
Then run an 'Unmatched' query both ways - employees to discipline and
discipline to employees. Fix an records that do not match.
Make the [employee #] field of the employee table a primary key.
Create a relationship between the table selecting Referential Integrity and
Cascade Update.
Now you can use a form/subform for employee/discipline setting the
Master/Child links using the [employee #].
I recommend creating another table that is a list of all disciplines to use
instead of typing them in each time. Then you would use a combo box to
select the discipline being applied to the employee.
--
Build a little, test a little.
"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.
|