Results 1 to 6 of 6
  1. #1
    nightheart is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    3

    Table relationship - cascading data into multi tables

    Hi,

    I'm both new to the forum and to access.

    I'm currently using Access 2010 and I'm working on a database project. My question is related to table relationships. Within that project I do have a table that is related to other three tables where that table is the parent. The problem here is that once that table is updated or have a new value it never cascades it down to the other tables.
    1- How to have multi relationship to the same field on the same table from different tables?
    2- how to cascade the updates to the related fields?
    3- Is there any way to force the data update to other tables?



    Thanks

  2. #2
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    Enforcing a referential integrity will solve it.Post screenshot of your table relationships.

  3. #3
    nightheart is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    3
    thank you very for the reply.

    I had already got my table related using such option, but nothing being updated in any of the tables as per the sample db attached.
    Attached Files Attached Files

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you really need a table to identify Month?
    I think it would be helpful to you and the reader, if you were to list your business rules/facts.
    Naming tables tbl1, tbl2 does not convey anything to the reader.
    In plain English What is your database about?

  5. #5
    nightheart is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Posts
    3
    Thank you very much for the reply.

    The db I'm trying to create is an expenses db that tracks them by month, so that is why I had a table of moths there, I might be wrong with the design. The attached one was a draft of the db layout. I'll attach a snapshot of the final shortly.

  6. #6
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    FWIW, I looked at your example. I think you need to change the structure. You have two tables - withdrawals and transfers - that should be one table. Shouldn't need the month table. You should take the time to give meaningful names to objects... a lot easier to understand.

    Here are links to expense database templates that might help you.
    2003 - http://office.microsoft.com/en-us/te...001017508.aspx
    2007 - http://office.microsoft.com/en-us/te...010238208.aspx
    2010 - http://access.microsofttemplates.org...-template.html

    And databaseanswers.com has many examples: http://databaseanswers.org/data_models/

    If you cut out the bank table, deposit table and withdrawal table, this might work for you (you don't have to use every table):
    http://databaseanswers.org/data_mode...unds/index.htm

    Without a better understanding of your requirements, it is difficult to be more specific.

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

Similar Threads

  1. Replies: 11
    Last Post: 08-22-2012, 06:34 AM
  2. Replies: 4
    Last Post: 08-08-2012, 05:49 PM
  3. Replies: 2
    Last Post: 01-10-2012, 06:41 PM
  4. Multi-table Data entry form
    By halpme in forum Forms
    Replies: 3
    Last Post: 11-10-2011, 02:48 PM
  5. Replies: 0
    Last Post: 03-15-2010, 02:38 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