Results 1 to 2 of 2
  1. #1
    bryanno is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Posts
    2

    Unhappy Problem with subdatasheet


    I am having a problem using subdatasheets. I am building a basic database that stores information about voulunteers(members) for a non profit organization. Most members are couples. The husband is generally the primary member. I want to list the wife as a secondary member in a subdatasheet. I want to only display the wife of the member that has been selected, rather than show the entire secondary member table (table of wives). Any suggestions?

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Relate both submembers not only to the primary key, but also relate the submembers to each other; or, create a junction table relating the primary key to each submember.

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

Similar Threads

  1. Wierd subdatasheet problem
    By Lynnwood in forum Access
    Replies: 0
    Last Post: 10-30-2009, 08:12 PM
  2. query problem i have a problem wi
    By maxx3 in forum Queries
    Replies: 0
    Last Post: 06-29-2009, 02:29 AM

Tags for this Thread

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