Link to home
Start Free TrialLog in
Avatar of TechMan4Ever
TechMan4Ever

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TechMan4Ever
TechMan4Ever

ASKER

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!
basically my question is how to send new record command to a subform..... thx.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.