We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 2003 - How to auto-insert records into a table when a record is inserted in a different table

sah18
sah18 asked
on
Medium Priority
263 Views
Last Modified: 2012-08-14
I am trying to create a very simple Access database for scheduling visits.  What I would like to have happen, is when a new record is inserted into the tblBaseline, that at the time that record is inserted/saved that all future visits (6 months apart) get inserted into a second table: tblScheduledVisits.

For example, if I insert this record into tblBaseline:
StudyID = 1001, baseline_visit_date = 12/1/2010

I want to have the following records inserted into tblScheduledVisits:
StudyID = 1001, visit_date = [baseline_visit_date] + 6 months
StudyID = 1001, visit_date = [baseline_visit_date] + 12 months
StudyID = 1001, visit_date = [baseline_visit_date] + 18 months

all the way up to a 5 year period.

I have no idea how to code something like this.  Is anyone able to help?
Scheduling.mdb
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
This is exactly what I needed.  Thank you very much!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.