Creating blank child record when parent is created

  • Thread starter Thread starter sharon
  • Start date Start date
S

sharon

Can someone explain how to create a blank record in a
child table when the corresponding record is created in
the parent table?

Please email me directly at:
(e-mail address removed)

I really need some help with this.

Thank you.
 
Can someone explain how to create a blank record in a
child table when the corresponding record is created in
the parent table?
Click to expand...
The easiest way to do this is to use a subform for the child table records.
When you bind the form and the subform using the ParentLinkField and
ChildLinkField properties, any new records you enter will have the correct
FK value set automatically.

HTH

Tim F

--
Please email me directly at:
(e-mail address removed)
Click to expand...

Oh damn, she'll never see it...
 
Actually, most of the time, you should NOT have to have a child record
added.

All your queries will function just fine if you use left joins (that means
that parent records will be included in the query/report even when NO child
record is present). Often, in place of using left joins, a bad solution is
to start throwing blank child records all over the place, and that is really
a messy solution.

Are you really really really sure you need to do such a dumb thing, and add
blank records all over the place?
 
Back
Top