Share via

Multiple Subtables into One Table

Anonymous
2013-02-21T00:25:42+00:00

For my project, I'm looking for a way to have 2 or 3 sub tables that feed into one main table. So if 'A' table had a drop down box, it would show me tables 'B', 'C', and 'D'.

Is there any way I can do this? Every time I try, it will only let me choose 1 table to use as my sub table. Any help would be appreciated!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2013-02-21T01:44:06+00:00

    I'm not sure I follow what you want.

    Access is a relational database and, as such, a proper structure is to have multiple tables, usually in a one to many relationship. The usually way these are displayed in a form is the use of subforms, sometimes on a Tab control.

    If that's what you need to do, then use the Subform wizard, you place a subform on your main form.

    If that's not what you need, please elaborate with real examples of your data.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-02-21T00:48:02+00:00

    Karl, thanks for the reply.

    How can I do this easily? Can you break it down in steps for me? Thanks!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-02-21T00:43:09+00:00

    Don't do it that way.  Use a form/subform, setting the Master/Child links and combo boxes as needed to choose the other table records.

    Was this answer helpful?

    0 comments