Append Query

[NeilPattison]

I think i need to use an append query for this but have never used on before so just need to know if it is the right thing to do.

I have two tables [tblPoles] and [tblPoleInstructions].

I have a form set up for [tblPoles] so the user can enter the data required. One piece of data required is a start date. The only fields the tables have in common are the PK which is the Pole Number and the start date.

I want the user to be able to enter the start date on the form for tblPoles and it to be automatcially entered into tblPoleInstructions. Is an append query the right way to do this?

Any help would be greatly appreciated.

 

[PHV]

Provided the relationships are properly set you may consider following the subform wizard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[NeilPattison]

Thanks I've figured this out now