Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Access Relationship Display Question

    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

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    I cannot comment on Access 2003, but in Access 2000 you can only show the subdatasheet for one relationship in the table's datasheet view.

    However, you could set up a form based on Person that has two subforms, one based on Shoe and the other based on Hobbies. Set up the subforms in either continuous or datasheet view, and be sure to join the main form and the subforms on PersonID.

    BTW, it is a bad idea to include spaces in the names of fields, tables, forms, controls, etc.

  3. #3
    Join Date
    Feb 2006
    Posts
    2
    Darn it, I just like to go through the DB and look at all of the relationships. I may set up a form as you suggested.

    On the field naming, I just wrote it like that for readability on my post. =)

    Thanks for your help.

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    You're welcome, and good luck with your project.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Question about the future of Access
    By kantell in forum Access
    Replies: 0
    Last Post: 11-04-2008, 11:43 AM
  2. Replies: 0
    Last Post: 10-03-2006, 03:16 AM
  3. Access Question regarding JPEG files
    By amosstarz in forum Security
    Replies: 1
    Last Post: 09-01-2006, 04:17 PM
  4. Replies: 1
    Last Post: 02-27-2006, 07:46 AM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums