I want to save my time

[maniatis]

here's the problem:

I have a table named case and it is connected with a table named categories .the table categories is connected to a table named subcategories.

For every record in the table case the categories and the subcategories are the same.

Is there a way that I can copy all the records of the categories and the subcategories for every record in the table Case or I have to do it only with copy & paste.

Thanks for your time.

 

[statsman]

Sounds like you want:

An append query if you're saving them to an existing table

Or a make table query if you want them in a new table.