Update Query - multiple rows

[Tigereyes78]

Hello all,
Having a blonde moment!
I have a properties table where there is a row for each property with a reference number. [property ref], [property name] etc
In a second table are the charges for each type of maintenance for each property. [Property ref], [Charge category], [Charge amount]
When a new property is added i need to append the charges table with several rows, completing the reference number and category fields but leaving the charge empty for the user to complete.

eg - property ref, cleaning
property ref, boiler service
property ref, water
property ref, laundry

I can do the append to add the missing reference number in one row but how do i repeat that to get several rows with all the categories i require?

Thank you

 

[Galaxiom]

No insert query is required. It can be done in the form with the records for the related table added automatically as the values are entered by the user. The Charge Categories are made to appear in the subform before the records exist using an outer join in the subform recordsource.

It would be a similarly structured form to the example in Post 3 of this thread. You won't need the VBA though.