Hi all.

I have an Access DB containing 3 tables (STMBIOGR, STMAOS, STCSESSD).
I am using the student_id field in STMBIOGR to find all courses that student is on in STMAOS.

My problem arises here as I need to retrieve the aos_code and aos_period fields from STMAOS (there may be multiple records) and then use them to get the aos_code, aos_period, and full_desc fields from STCSESSD. I don't want to display the fields I retrieve from STMAOS but need to hold them somewhere and then iterate through them to get the name of each course.

ie.
If STMAOS contains 2 records for a student_id, I need to iterate through these and use the aos_code and aos_period fields to get the previously mentioned fields from STCSESSD.

I just can't figure out how to hold the STMAOS data and then reiterate through it to get the name for each course.

nb. The course code consists of both the aos_code and aos_period fields so I need to just get the data from STCSESSD where that record matches both of those fields.

Any help that you could offer would be greatly appreciated as I fear I`ve bitten off more than I can chew with this one!

Hermiod

I find your post a little confusing however:

;;;I just can't figure out how to hold the STMAOS data and then reiterate through it to get the name for each course
You could place these records in an array. Find all the code here:
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=161

Wind is your friend
Matt

It is confusing! The post didn't make at alot of sense to me and I wrote it.

Thanks for the reply but a colleague helped me out and showed me how to get all the data from STMAOS and the matched data from STCSESSD in one sql string.

You can do alot more with SQL than I thought you could!