|I am creating an application to do utility billing. I want to be able to add notes/comments to each customer/meter. I'm a newbie so I am asking what is the best way to enter and store these notes. Right now I have a access database, I have a table dedicated to just the notes. I am storing date and time stamp as to when the note was added, the customer number and the note. Each note is stored in a record for each customer. I have a textbox on the windows form that I enter and display the information.
Is this the best way or is there a better/easier way. Since I am new I might be overlooking something.
With my code now I am having trouble combining the records for each customer and displaying them in the textbox. If the way I am doing it works then I will post other help on that issue.
Thanks in advance...