Results 1 to 4 of 4
  1. #1
    Awaleed is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Aug 2015
    Posts
    3

    Post How many Cascaded one-to-many Relationship can be accommodated in one access FORM


    Dear All,

    Im seeking help, in the following issue... I'm totally new in access, please ignore if I'm fail to explain my question.

    I want to make a Master form which has many subforms, All the sub forms are related to each other with one to many relationships.
    I tried to build but failed.
    I tried builtin wizard which only take 3 forms, mean one master two slave, I want to put more then 2 subforms which are related to each other by one-to-many relation.

    If some one need more explanation please ask. Click image for larger version. 

Name:	ss.JPG 
Views:	10 
Size:	30.2 KB 
ID:	21595

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    I think the limit is 7 nested forms. Only the last form can be in datasheet view.

    How did your attempt fail, what went wrong - error message, wrong results, nothing happens?

    What do you not understand about manually building form/subform arrangement? Do you know what a Subform Container control is?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Awaleed, I think you show a picture of table relationships (absolute max - 32 per table) created by the relationship builder. If I am correct this has nothing to do with the number of subforms or subreports (7) you can have on a main form.

    June: or is this a relationship builder between form and sub forms, something I'm not familiar with since I don't use version 2013?
    Thanks.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    It is image of Relationships window. OP just trying to show the hierarchy of table relationships upon which wants to base form/subforms.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Sub-Form with Cascaded Records
    By znxm0i in forum Forms
    Replies: 3
    Last Post: 07-10-2015, 07:15 AM
  2. Cascaded Multi Select List Box - Query code?
    By Torinjr in forum Queries
    Replies: 4
    Last Post: 06-29-2015, 03:26 PM
  3. Replies: 3
    Last Post: 03-19-2015, 05:26 PM
  4. Replies: 2
    Last Post: 12-07-2014, 10:03 PM
  5. Cascaded comboboxes in a form
    By luca in forum Forms
    Replies: 2
    Last Post: 11-22-2009, 05:36 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