Thanks for your comments Rick. I have a number of tables they a

Employeetble
Employee Name (PK)

Positiontble
Position Name (PK)

Work Intructiontble
Position Name
WI Description

Competencytble
Employee Name
Position Name
WI Description
Date Trained

I am trying to use the competency table to record training for different
work instructions for employees, work instruction must be allocated to a
position and an employee to a position (nb. an employee can have a number a
positions hence a great deal of work instructions).

Your help is appreciated.

Thanks

"Rick Brandt" wrote:

Try Hard wrote:
Bye removing the "Link Child Fields" and "Link Master Fields" the
records are no longer displayed unless their are other parts of the
record filled in. I would the record to stay so I can track were they
are up to.

Can this be done????????

It is done all the time. Sounds like you have incorrect relationships
between the two tables or that you do not have the relationship properly
configured with the MasterLink and ChildLink properties.

What field or fields relate the two tables? Those same fields are what
should be entered into the link properties of the subform.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com