+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, MS Access - Create table linked to a Record in another table in Technical; I have an asset database which is pretty flat in design. It has a record for "Comments", and at the ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    MS Access - Create table linked to a Record in another table

    I have an asset database which is pretty flat in design. It has a record for "Comments", and at the minute these just get overwritten next time something else is to be recorded.

    I was trying to think of a way that I could record everyting that is entered in the comments record, to buid a history of that asset. But I cannot think how i would go about it. Im thinking another table, linked to the asset, but how to go about implementing it I'm not too sure.

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    Heres how I would do it, you have your assets table obviously with a uid to identify them and act as the primary key. You then have a seporate comments table which has its own uid to id comments and a AssetUID which is the UID of the asset the comment relates to, you want a comment field obviously and probably a date field to.

    You then set up a relationship between the UID of the Asset and the ASSetUID field of the comments table. This will be a one to many relationship as there will be one asset to possibly many comments.

    To retrive the comments for each field you could use a subform in access which linked to the comments table which will filter based on the relationship or use a query if you are grabbing the data for an external app like a web page.

  3. Thanks to SYNACK from:

    RabbieBurns (5th May 2010)

  4. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    Cheers, will give it a go tomorrw. Not too sure about forms - my weakness. But will see what I can do.



SHARE:
+ Post New Thread

Similar Threads

  1. SMART Table
    By Otter in forum General Chat
    Replies: 7
    Last Post: 11th August 2011, 03:23 AM
  2. [Pics] A Periodic Table [?] Oh Yes!
    By DaveP in forum Jokes/Interweb Things
    Replies: 19
    Last Post: 31st March 2010, 12:47 PM
  3. Microsoft Access Fill All Blanks in Table
    By RabbieBurns in forum Office Software
    Replies: 17
    Last Post: 18th March 2010, 01:03 PM
  4. Replies: 0
    Last Post: 25th June 2009, 04:45 PM
  5. Time table
    By thegrassisgreener in forum General Chat
    Replies: 35
    Last Post: 27th November 2007, 05:39 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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