Hi,



I am newbie at Microsoft Access 2000, so please bear me with me with my 

novice questions!



I have 6 tables as listed below:



4 Tables contain Survey Infomation:

52 fields, 35 fields, 30 fields, 41 fields



1 Table Called Main which has all the basic information:

has 49 fields



1 Table called Contact which has contact information;

has 20 fields



They are all currently one-to-one from the Main to the other tables.  Its 

tempting to role them. I have quite a bit of a problem with managing the 

relationships between the five tables. nto one table with a 227 fields. We 

expect to have only about 300 records total and around 5 users using the 

database.



Is it wise to merge the 6 tables into 1 table? How should I manage the 

information more efficently?