Results 1 to 2 of 2
  1. #1
    Jay1 is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Sep 2018
    Posts
    1

    Link all my data to one source table

    Hi,

    So, I am Setting up a database for a number of Projects.

    *Table 1 (Primary table): Projectname_Projectfocus_approval date_approved by.

    The subsequent tables are for other Informations like Benefits, Investments, Return on Investment into the Projects, which also have columns for Project_name for example.


    Now, I want to link all the tables to the Primary table (table 1), so that when project Name is changed in Table 1 (Primary), it affects all the other tables.


    and also create a Combo Box in the forms that follows the same logic.



    Thanks in advance

  2. #2
    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,716
    To understand your table setup requires some knowledge of the business/processes involved.
    Here is a link to various articles on Database Planning and Design. I recommend working through 1 or 2 of the tutorials from RogersAccessLibrary mentioned in the link.

    Good luck.

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

Similar Threads

  1. Replies: 4
    Last Post: 09-17-2018, 10:15 AM
  2. Replies: 1
    Last Post: 09-02-2014, 09:57 AM
  3. Replies: 2
    Last Post: 12-17-2012, 03:46 PM
  4. Replies: 25
    Last Post: 08-01-2012, 05:22 PM
  5. linked table displaying different data than source
    By wil in forum Import/Export Data
    Replies: 1
    Last Post: 08-06-2010, 07:13 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