By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

Combining data from opposite ends of a 5 table chain

P: 2
I have 5 tables set up as follows:

A-b-C-d-E

Tables b and d are linking tables because A and C have a many-to-many relationship and so do C and E. I would like to set up a query whereby Access will tell me which records of E are connected to any single record of A that I specify.

If this is too abstract, A = students (e.g. Fred Bloggs), C = classes (e.g. e.g. Maths Group B for a particular year of students) and E = teachers (e.g. Mr Bloggs). I would like to know which teachers any particular student has, and also - in the opposite direction - which students any particular teacher has.
Aug 9 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 179
I've said this a few times in here already. M:M reationships are not recommended by experts (they should be avoided as much as possible).

I don't fully understand your problem, but if you look back through this forum (Under "Access"), you will find a post called "Forms with M:M relationships". Go back 11 to 12 days. Read through the replies and see if this helps at all. If not, then could you please explain your problem in more detail?

comteck
Aug 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.