mistake. Shows or whose.
sorry I don't follow?
i would introduce a attendee table that would link the meeting key to the attendee. This assumes contacts will attend many meetings
not sure that is the easiest way I was hoping there would be something I could do within the relationships.
basically if I have a client meeting a journalist, I would look up the journalist from contacts and then look up the client employee from contacts and have a line in my portal that say's this employee will be meeting this journalist.
I'm wondering if I can have something like kf_contact_id and kf_client_contact_id within meetings and they both link to kp_contact-id. maybe if I have two occurrences of the contacts table it would work?
Does your Graph look like this?
Events --< Meetings >-- Contact
could i use 2 occurrences of the contacts table?
Shouldn't need to. If you want two Contacts on each meeting, then you just put two ContactID fields on each Meeting record.
Alternately, if you want multiple Contacts to be able to attend any given meeting, then you need another table, like fclark mentioned. This is because you need a many-to-many join between Meetings and Contact, like this:
Events --< Meetings >-- MeetingAttendance --< Contact
where each record in MeetingAttendance represents the unique combination of one person at one meeting. Depends on your modeling needs, and whether you think more than two contacts would ever attend a single meeting. (Hint: Yes.)