Deciding on Tables

F

frommonc

Sorry, new to access. May be silly question, but..... Setting up contact
database. Contacts can be of type client, friend, vendor, media, etc...
Contacts may also belong to more than one type. Trying to decide if should
setup seperate table for each type with contact info, or setup one contact
table and and one table that contains every type and setup relationship to
contact table.. If so, how do i enable ability to select more than one type
in contact table.

Thanks!!
 
K

KARL DEWEY

Set up a third table with one-to-many from Contact to join table with two
fields - Contact key and Type key. Set up one-to-many from Type table to
join table.

Set Cascade updates.
 
Top