Form Design

[dls61721]

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.

 

[Bernard Peek]

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.

Open each table in design view and take a look at the employee# field in
each of them. Are they both numeric fields? If so are they the same type
of numeric field; integer, long integer etc?

 

[KARL DEWEY]

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.

 

[John W. Vinson]

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.