Conference Room Database

[Tom G]

I created a database to track conference calls. I have all the necessary
fields (Conference name, Start time, stop time, date) The problem I have is
the participants field. In a conference call we will have at leas three
sites.

I want to be able to call up a conference by name and see what sites were in
the call.
Thanks,

 

[Ed Warren]

The problem is you have a 'participants field'. You need to think in
'relational terms' and have a table to handle the many to many relationship
between calls and participants

each participant can be part of many conference calls
each conference call can have many participants

so you need (at least) three tables.
tblcalls
callid(primary key) date/time of call (other stuff about the call
tblparticipants
participantID(primary key)
lastname firstname phonenumber (other stuff about the
participant)
tblcall_participants
callid(foreign key -- refers back to the calls table) (Primary key
composite key from callid and participantid). ParticipantID (foreign key --
refers back to the participantID)

Now you can set up realtionships, queries, forms, and reports to handle the
many:many relationship.

note: other tables that might be players:
organizations 1: M Participants
Call agendaItems M:1 calls

Ed Warren.