troubleshooting Question

Create a new record in one table that includes data from another table in Access 2007

Avatar of mstoolmi
mstoolmiFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution332 ViewsLast Modified:
I have a client table that is linked to a number of other tables that contain survey instruments.  On the client record form, I have buttons that connects to each survey and create a new record.  When the survey record is created, I would like the client_id field to be populated by same id from the client table record where the button was clicked.  I thought that the best way to handle it was to create a temporary variable and set it equal to the id in the client table, then create the new record in the survey table, and set the client_id field to the temporary variable.  

How do you set the client_id to the temporary variable?  Or is there another way to set the client_id field to the right id?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros