Master & Child Links

  • Thread starter Thread starter cheswyck
  • Start date Start date
C

cheswyck

I'm entering time usage for employees. The master has
Client, Job and Date. The child has Employee, Time and
Function. I have the child in continuous format but I
can't enter more than one record. All of the control
fields except date & time are linked to other tables. Is
it the Master & Child Link properties that is causing this
problem? I'm using Access/2000. What can I do to get
this thing to work?
 
cheswyck said:
I'm entering time usage for employees. The master has
Client, Job and Date. The child has Employee, Time and
Function. I have the child in continuous format but I
can't enter more than one record. All of the control
fields except date & time are linked to other tables. Is
it the Master & Child Link properties that is causing this
problem? I'm using Access/2000. What can I do to get
this thing to work?
Click to expand...

Normally a subform displays records that are filtered to the rows that are
related to the current parent record. For that to happen, the MasterLink and
ChildLink properties are used to establish which are the common fields between
the two forms. You appear to have no common fields.

These properties also (normally) establish the default value for the linking
fields in the subform records added using the form. If you have nothing set for
these properties then those fields are likely picking up their default values or
are being left null. If those fields are required to be unique then you will
either not be able to add records at all or you will only be allowed to enter
one. All subsequent attempts to add records would raise a "duplicate key"
error.
 
Back
Top