MS Access

This is rather simple question but I was not able to find an example on this... so the setup is rather basic...

I have one table called Client and other Call (their are linked by ClientID), 1 to Many.

I want to have one form that has client info on it and then have ability to "make" new calls which would write to calls table only info related to a call but still "linked" by the one specific clientID field.. I tried to use quaries but that only links one to one... and I could not find a way to make multiple records while still staying on the same clientID... please advise or if you can point me to examples I would greatly appreciate.

Thank you and have a great day!
Who is Participating?
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Based on your description I recommend...
A main form that has your Client info, with Client table as recordsource
A subform on that main form that would be your Call info, with Call table as recordsource.  In Form Design, subform control make sure your Link Child Fields-LinkMasterField is ClientID.  If you envision other 1:M subforms on this main form (say payment history, client status history, whatever), you can use a tab control and put the Call subform on one tab, the others on others.  
TechMan4EverAuthor Commented:
Thank you, now how would I make it so that it always open a new record source with clientid already inserted into the subform? I don't want to see other calls already made, just insert this new one... thank you for your help!
TechMan4EverAuthor Commented:
basically my question is how to send new record command to a subform..... thx.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.