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

#1

I suspect your tables are not well normalized but, without a more explicit
example, it's difficult to say what needs to be done. Could you provide some
'real' data?

Such 'wide' tables with such complex keys are unusual in a well designed
database.

"R W Pearson" <rwpearson2002 (AT) comcast (DOT) net> wrote

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.database.ms-access comp.database.ms-access

Re: Fields from split table do not appear in Form View in Access 2000 - 07-25-2003 , 06:44 PM