MS Access

Posted on 2012-09-22
Medium Priority
Last Modified: 2012-10-19
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!
Question by:TechMan4Ever
  • 2
LVL 66

Accepted Solution

Jim Horn earned 2000 total points
ID: 38425171
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.  

Author Comment

ID: 38425344
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!

Author Comment

ID: 38425518
basically my question is how to send new record command to a subform..... thx.
LVL 50

Expert Comment

by:Martin Liss
ID: 38513423
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question