SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Access database

  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2009
    Posts
    73
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access database

    Hi Everyone

    For my upcoming project I want my database in access2007, to have a particular field updated across say 4 tables.

    For instance I have field called product_code in one table, so when I update the record in this field it will update all the tables in the database that have the field name product_code of the same record.

    How do I achieve this, hopefully i have made sense?

  2. #2
    SitePoint Evangelist
    Join Date
    Jun 2007
    Location
    North Yorkshire, UK
    Posts
    483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to establish relationships between the tables and enforce referential integrity.

    Good explanation and how to at

    http://office.microsoft.com/en-us/ac...205341033.aspx


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •