Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2003
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subdatasheets (2003)

    I have problems using a subdatasheet. I am sure that it is very simple, but perhaps thats why I can't find a solution in the manual.

    I use Access 2003 with Access 2000 file format for a database that has two related tables. One table contains CD titles and the other contains individual track details, the two tables are related through the cd title field. When I open subdatasheets in the CD table it does not list the individual titles from the related table. These titles are shown if I have entered them using the subdatasheet, but not if they are entered directly into the related table.

    I have previously set up similar tables and these work correctly, but I am not sure what I have/have not done this time. Can anyone suggest a simple and obvious solution to this that I might have overlooked?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subdatasheets (2003)

    Are you sure you're including the correct foreign key when you enter them directly into the table? BTW, it normally isn't a good idea to enter data directly into a table or query, with or without subdatasheets. It's best to use forms and subforms so that you can control the events.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Oct 2003
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subdatasheets (2003)

    Thank you - yes, this was exactly the problem. Somehow I had tied the relationship to the wrong field.

    And yes, I know that you are supposed to enter data via forms, but they do take time to design and I am not really sure what additional control they give.

    Thanks again for the solution.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Subdatasheets (2003)

    Well, one of the things they can control is keeping you from entering the wrong relationship! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •