What kind of query do I use? HELP!!!

[Guest]

My set up is as follows:

tble_week
weekID (PK)
RecWk

tble_enquiry
RecWk
EnquiryID (PK)
Enquiry

tble_subenq
EnquiryID
SubenqID (PK)
SubEnq
SubEnqNo


In the week table I have all 52 weeks of next year (date ending Friday).
For each week, I need 3 enquiry types
Every enquiry I have specific subenquiry types.

Can I use a query to do this. I hope I don't have to do it manually!

thanks

 

[Guest]

Im being stupid again

worked it out.

update query and an append query.