1 record, 4 forms, 3 tables

[dfedosoff]

I have a long data entry form which has been split into 4 separate forms. The data for a record had to be split into 3 tables (because i have over 600 variables). I created a NEXT SCREEN button which is supposed to open up the following form and insert the Primary Key so additional data can be added. Now the CLIENTID does go into some of the forms and data will save successfully but not on the one where all 3 tables are in the query. No matter what I try when I enter data into this form it doesn't save it. Could it because of the way of the relationships are set up? Or just the way the query in the form was created?

I have a link to the picture of the query as well as the NEXT SCREEN code. I hope this enough to help me answer the question.
Thanks in advance.

 

[Mr. B]

When you say that you "have over 600 variables" are you saying that you have that many fields for data entry and that is why you have had to split the data into 3 tables? If this is true, I would really suspect that the structure of your database is not correct. I have been developing databases for almost 20 years and have been observing the development of databases by others for the same length of time and I have never seen a normalized database that needed that many fields.

When you get your database designed correctly your data entry problems will be much more manageable.

I know this is not the answer to your question, but just providing you with a way to do something is not necessarily the best way to try to assist someone.

 

[dfedosoff]

This database captures clinical data using several survey instruments (questionnaires). For example, on the baseline visit alone there is a 30 page document a person completes. What would you suggest I do to make this work better?

 

[G37Sam]

I believe Access limits the number of fields per table to 255 anyways
http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx

If broken down into 3 tables, linked one-one by clientID, then 3 forms should do. I don't see why you'd have an issue

 

[Mr. B]

There may very well be a lot of data to be captured, but I can't make suggestions without knowing more about the structure of the data. I would have to make too many assumptions to offer many suggestions.

Is the document structured with multiple choice answers or does it require all textual type responses?

Most people here would not mind trying t assist you with the design of the database but we would have to have many more details.