Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010

    One-way link between tables

    Hi everybody,

    I'm trying to create a one-way relation between two table.
    The matter is I'm only able to create such a relation:

    Table A and table B.

    Changes to Table A are passed on Table B
    Changes to Table B are passed on Table A

    Otherwise my task is:

    Changes to Table A are passed on Table B
    Changes to Table B are NOT passed on Table A

    So we are free to modify table B, this not will change table A.
    I hope I cleary explained my problem.


  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    well now...database designers probably would question you with a 'why' on this...because once data is in a db it shouldn't migrate from table to table... be that as it may; you can run an AppendQuery or UpdateQuery (depending on which is appropriate) that will accomplish what you need.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2010, 08:29 PM
  2. How do I link existing tables?
    By jsbdiver in forum Programming
    Replies: 0
    Last Post: 05-24-2010, 02:53 PM
  3. Join three or more tables in many to many link
    By elicoten in forum Database Design
    Replies: 3
    Last Post: 02-04-2010, 06:51 PM
  4. Best way to link tables together?
    By marleyuk in forum Access
    Replies: 1
    Last Post: 06-07-2009, 08:44 AM
  5. Unable to import or link tables through odbc in Access SP2
    By Dave Jenkins in forum Import/Export Data
    Replies: 3
    Last Post: 11-09-2005, 11:51 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