K
kmarsh23
Guest
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
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
