I have a table called clients with fields labeled fname, lname, dob, intakedate. I have a second table called ClientNotes, the fields are notedate and cnotes. I've tried queries and forms but it looks sloppy and doesn't work very well. What I want is to be able to pick a client and write notes about that client and include the date the note was written. I would then at some point want to pull up a client and look at the notes I wrote by picking the date of the note.
I hope this was clear - any help would be most appreciated.