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.