_PLEASE_ Help! Project nearly due in!

[OutbackInvestments]

Hi,
Im making a database for a school project and I have run into a small problem. I have a form for meeting minutes, and attendances to the meeting. The attendance is from PresentTable (many to many parser) that takes a member and makes them attend a meeting. However, the member can attend the meeting twice. E.g. Meeting Aug-3-00 (1) has attendance by Joe Bloggs, Robert Bissonnette and Joe Bloggs. How do I validate this, as I cannot make the memberID unique, the member can attend other meetings.
Please help!

Thanks,
R. Bissonnette

 

[Richie]

Couple of things I don't understand why can't each member have a unique ID they are all different people aren't they? Secondly how does Joe Bloggs attend the same meeting twice, does he leave and then return?

 

[Pat Hartman]

The meeting itself needs a unique ID. Then you would use both MeetingID and MemberID to record a person's attendance.

 

[OutbackInvestments]

In response to both messages, I do have those things. The meeting does have an ID for itself, and the Members have an ID.
MeetingTable has MeetingID
MemberTable has MemberID
Present Table links MeetingID and MemberID
what I want, is to make it so that if MeetingID and MemberID match in two records, than it is invalid. I can make it check and display a duplicate, but I cannot invalidate them.

 

[Pat Hartman]

Change the primary key of the attendance table to include both MeetingID and MemberID.

 

[OutbackInvestments]

Awesome. I didnt know that you could have double primary keys! I made the change, but I dont think I can put it into my project. I've already done the documentation (95 pages) and I dont want to re-print the whole meeting section. And it actually sounds good if I leave errors in. Thanks for your help though!