Setup Help

[hornfan11]

I am trying to setup a database that allows me to monitor company meetings and the interaction we have with our contacts.

I envision some of the following tables but cannot make them relate to one another.

Meeting (Meeting_Date, Meeting_Summary)
Contacts (Contact_Name, Contact_Address, etc.)
Attendees (Attendee_Name, Attendee_Adress, etc.)
File (File_Name, File_Type) (Files shown or used at the meeting)

 

[amigos]

To make relationshiop between tables, related fields must be the same type fields.
maybe that will helps?

 

[hornfan11]

Yes I understand that but I can't come up with the proper way to make it all flow correctly.

 

[amigos]

What do you mean?

 

[hornfan11]

If I understand you first post you mean:

Meeting Table
Meeting_ID (Primary Key)
Meeting_Date
Meeting_Summary


File Table
File_ID (Primary key)
File_Name
File_Type
Meeting_ID

Would be related by the the Meeting_ID.

I can't seem to make all the tables relate properly.

I do know a Meeting can have one-to-many Contacts, one-to-many Attendees, and one-to-many Files.

Does this make any sense?

 

[amigos]

Can you use more than one file on one meeting?
can one file be used on more than one meeting?

 

[hornfan11]

Can you use more than one file on one meeting?

Yes.


can one file be used on more than one meeting?

No.

 

[amigos]

are Meeting_ID fileds the same Data Type in both tables (in design view)?

 

[hornfan11]

I guess what I am trying to say is logically I can't figure out what would be the best way set-up the databse.

 

[amigos]

What do you mean "set up database"?
to define relationships between tables?