Hi everyone,
I have a database that tracks customer issues. All issue notes are stored in a Notes table.
Issuenotes
IssuenoteID-PK
EntryDate
EnteredBy
IssueNote
IssueID FK
I'm trying to think ahead of a possible user request. For example, if I go to issue 50 and it has 5 notes, they will currently show in a continuous form in chronological order with the date entered and who entered the note.
Is there a way to do something like ColumnHistory into a text box or similar that combines all the Notes from a issue into a "snapshot" type view? I can see folks wanting to pull this data into Excel and wanting an overall view.
Thanks for any help!