Form Design

  • Thread starter Thread starter dls61721
  • Start date Start date
D

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.
 
In message said:
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.
Click to expand...

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?
 
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.
 
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.
Click to expand...

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.
 
Back
Top