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 ...
5th May 2010, 05:00 AM #1
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.
5th May 2010, 05:06 AM #2
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.
Thanks to SYNACK from:
RabbieBurns (5th May 2010)
5th May 2010, 09:52 AM #3
Cheers, will give it a go tomorrw. Not too sure about forms - my weakness. But will see what I can do.
By Otter in forum General Chat
Last Post: 11th August 2011, 03:23 AM
By DaveP in forum Jokes/Interweb Things
Last Post: 31st March 2010, 12:47 PM
By RabbieBurns in forum Office Software
Last Post: 18th March 2010, 01:03 PM
By edd in forum Office Software
Last Post: 25th June 2009, 04:45 PM
By thegrassisgreener in forum General Chat
Last Post: 27th November 2007, 05:39 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)