Problem 1

I am trying to build a DataBase to enter survey information on. I started with multiple tables for each section of the survey, linking them together by employee id. i pulled the employee info from an excel spreadsheet. when i built my form to enter the info on i ran into a problem. i used a qry to pull all of the tables together. every time i entered info into the survey fields it would changed the ID to zero. If i went back and changed it, it would change the next time i entered info on another section of the form that was linked to another table.

Problem 2
I needed to get this going so i thought i would take all of the linking problems out and use one table. Keep in mind that each field has 5 possible answers i was pulling from list tables. My new table that i created has 167 fields. after 151 it wont let me enter any mor look up fields i get the error "Property value too large." can you help me on this.

Thanks
Kelby

Pat Hartman has some ideas for proper database structure when dealing with questionaiires here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=7063&highlight=answer+question