Automatically Insert New Record

[jbarbato]

Hi there,

I have three tables:
tbl_Team
tbl_Performance
tbl_Score

The relationship is 1:1 tbl_Team:tbl_Performance, and 1:1 tbl_Team:tbl_Score. It needs to be setup this way b/c different users have different permissions on these tables.

All 3 tables have Team_ID as a primary key. I want a new record inserted into tbl_Performance and tbl_Score with Team_ID every time a new record is inserted into tbl_Team. How do I go about doing this?

Thanks,
Jayme

 

[Remou]

Append queries in the After Insert event should suit.

 

[jbarbato]

Thanks - I was able to set up my append queries, but could you please elaborate on using the After Insert Event?

Thanks so much,
Jayme

 

[Remou]

Do you have a form for adding to tbl_Team? If so, check out the property sheet. One of the events is After Insert, you can add code to it to run your queries. If you do not have a form, create one.