Results 1 to 2 of 2
  1. #1
    Brian Gregg is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jun 2011
    Posts
    6

    Angry Sub Form

    I am trying to create a form and sub form in a database. I have created a one to many relationship between two tables. Both tables have exactly the same field properties to the field that is related.

    As per the instructions in the On Line Help for creating a subform, I click on the Form Wizard and select tables/queries and select the fields from each of the two tables. According to the instructions, when I have finished selecting fields and press next, I should then see a page which asks "How do you want to view your data", but does not include the Form with subform(s) button and Linked forms button, just a tabular type datasheet.

    This is a simple CD database with the main form showing the CD No. and title, and the subform should show the tracks for that CD, but I cannot get it to work.

    Any ideas, I would really appreciate help.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The subform should only be related to the one table. The main form contains the parent table fields and the subform contains the child table fields and they are linked by the common key.

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

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