Results 1 to 7 of 7
  1. #1
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30

    tables in a table

    Hi, new at the forum!



    Anyone know how to create a table that contains other tables? (e.g. indexkey, not whole table) I want to select a table from a combobox.

    bg

    Gostap

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Do you know the names of the tables or are they likely to change


    Sent from my iPhone using Tapatalk

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    http://stackoverflow.com/questions/2...ccess-database

    May be useful


    Sent from my iPhone using Tapatalk

  4. #4
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    thanks a lot for answers;
    to describe what I want to do, I will have a head forms where i from a combobox will choose different sub-forms. Maybe I don't need a table containing what sub-form I want?
    (hope you understand my English... )

  5. #5
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Hmmm the same thing applies really. Will the subforms always be the same ones? Or are they likely to change


    Sent from my iPhone using Tapatalk

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725

  7. #7
    gostap is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2017
    Posts
    30
    I will try to have same sub-form but change the datasource

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

Similar Threads

  1. Replies: 4
    Last Post: 08-24-2016, 06:48 AM
  2. Replies: 1
    Last Post: 02-06-2016, 08:01 AM
  3. Replies: 22
    Last Post: 04-25-2012, 10:03 AM
  4. table design: one big table vs. multiple small tables
    By lstairs in forum Database Design
    Replies: 3
    Last Post: 12-31-2009, 08:46 AM
  5. Joining tables two tables and another table that is not
    By DevintheDude in forum Database Design
    Replies: 0
    Last Post: 09-12-2007, 08:56 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