Results 1 to 2 of 2
  1. #1
    maagda_17 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    1

    Lightbulb how to create a new table that is linked to the form for EACH building

    I worked on access file. I need someone to figure out how to create a new table that is linked to the form for EACH building (TB-1, TB-2 etc) seperately instead of all info in one table like I have now. How I created a new Access file for each building instead of 1 form with multiple tables.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    That would go against normalization rules, and impractical to work with. Why do you want to do this? Would the fields within each table differ?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. VBA Create index on linked table
    By markjkubicki in forum Programming
    Replies: 3
    Last Post: 09-11-2018, 07:01 AM
  2. Create a linked table in Access
    By JuliusV in forum Access
    Replies: 1
    Last Post: 06-30-2015, 12:41 AM
  3. How to Create local copy of linked Table
    By behnam in forum Programming
    Replies: 3
    Last Post: 11-20-2014, 05:49 PM
  4. Replies: 2
    Last Post: 04-15-2014, 10:03 PM
  5. Create a linked table from excel using VBA
    By stigmatized in forum Import/Export Data
    Replies: 2
    Last Post: 08-04-2012, 01:21 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