many to many 2

[67peshawar294]

I am really confused! I started a project for training. Each employee views 12 PPT shows.
I have three tables:
tblemployee tblpresentation tblreview
employeeID presentationID reviewid
employee presentation employeeid
Position presentationid
Date review (yes/no)

As long as I manually enter the numbers in employeeID and presentationID everything works great!

 [u]tblreview[/u]
ReviewID	EmployeeID	PresentationID  Review
1	               1	       1	      FALSE
2	               1	       2	      FALSE
3	               1	       3	      FALSE
4	               2	       1	      FALSE
5	               2	       2	      FALSE
6	               2	       3	      FALSE
7	               3	       1	      FALSE
8	               3	       2	      FALSE
9	               3	       3	      FALSE

each employee has to view 3 presentations (eventually 12)
how do I populate the tblreview automatically???
THERE ARE 22 EMPLOYEES!!!!! I would like to enter a new employee and have the number of ppt presentation automatically be entered in the tblreview.
thanks jim

 

[traingamer]

Why not just add tblreview records as the employees review the presentations?

Do you want to add records again every time you add a new presentation?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[lespaul]

if you need to also list the presentations that haven't been reviewed, then you change the query to a LEFT/RIGHT join instead of an INNER join.

Leslie

In times of universal deceit, telling the truth will be a revolutionary act. - George Orwell

 

[67peshawar294]

I got it! Just a lapse in brain power. The hampster that runs around charging my cortex must have taken a break.