Append query one record several times

[Bader]

Hi

I have a table with rooms each room have a number of gust

I want to append each room many times equal to the number of gusts


Thanks

 

[Galaxiom]

I think perhaps you should reconsider your data structure.

Please show us an image of your table relationships.