Howdy, I have Access 2000 and an interesting problem has popped up.
I have 3 tables.
Person
Person ID
Shoe
Shoe ID
Person ID
Hobbies
Hobby ID
Person ID
So, I have two 1-many relationships from the Person table to Shoe and Hobbies.
When I few, say, the Person table in access 2000, it wants me to choose which datasheet I want to view. So it only allows me to view either SHOE or HOBBIES! I want to view BOTH!!! Is there any way to do this?
Also, does, access 2003 allow for multiple data sheets to be displayed?
Thanks