I can not figure out how to have a table of names and another table with notedate and notes and then to use a form to add to a retreive notes for a given name

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.
Stephen MuncyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
your Client table must have Unique ClientID field (unique for every client)
your table ClientNotes must use the ClientID  as a Foreign key (multiple entry allowed)


then create a form with a subform, see this link how

https://support.office.com/en-US/article/Create-a-form-that-contains-a-subform-a-one-to-many-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b?CorrelationId=bcec7114-de9c-4536-a3e7-5c791ee61f72&ui=en-US&rs=en-US&ad=US

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rey Obrero (Capricorn1)Commented:
post at #a40657014 should resolve this problem.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.