Fields from split table do not appear in Form View in Access 2000

[R W Pearson]

I have two tables split (because there are over 255 columns). They share a
5 field primary key that is a foreign key in table 1.

table1 table2
------------ ------------
table2.pkey1 table2.pkey1
table2.pkey2 table2.pkey2
table2.pkey3 table2.pkey3
table2.pkey4 table2.pkey4
table2.pkey5 table2.pkey5
table1.field1 table2.field1
table1.field2 table2.field2
table1.field3

. .
. .
. .

table1.field180 table2.field143

I have a query:

table1.* table1.pkey1 table1.pkey2 table1.pkey3 table1.pkey4
show show show show show

table1.pkey5 table2.field1 table2.field2 . . .
show show show

Know my problem. I cannot get any fields from TABLE1 to appear for
selection in Form View. Any help is appreciated. Thanks.

 

[Van T. Dinh]

If you need more than 255 Fields, I am 99.9% certain that the Table is
unnormalised, possibly the Table Structure is not properly designed.

Since a Select Query can only return 255 Columns, you may have problems
getting all the required Fields for your Form also.

There is also a limit on the number of Controls on the Form (750+, I think).
It looks a bit more generous than the number of Fields but there are a lot
of non-data-related Controls you need on the Form, e.g. Label Controls.

Suggest you read up on Relational Database Design Theory and see if you have
the correct Table Structure.

HTH
Van T. Dinh
MVP (Access)