Bounding controls to Multiple tables

[Ayo]

I have a form with a lot of controls on it. I have 9 tables that I need
to use as the control source for this form. On the form I have a Tab control
with 4 Pages and each page contains about 200 textboxes and labels. The
parent form also contains about 100 textboxes, labels and commad buttons.
The controlas on the main form are all bounded to 1 of the nine tables.
The other eight tables have data that needs to go on the TabCtrl Pages. Each
of the other table is about 80 coulmns long.
I tried to create a query so that I can use it as the Record Source of
the form but I am get a "Too many fields defined" error. Is there another way
to do this without put all the fields into one query and still be able to
bound the form controls to their respective tables.

 

[Kevin B]

Create subforms for the 8 subordinate tables and then place the subforms on
the tab control. Link the master & child fields for each of the subforms and
you should be good to go.

 

[Ayo]

The problem is each page on the Tabctrl Pages is linked to 2 tables and, the
data view must be setup such that I will have labels on the left side and
the top of my data, for example:

| EXISTING CONFIGURATION PLANNED
CONFIGURATION
----------------------
|------------------------------------------------------------------------
TRX Radio Count | Data Data Data Data
Data Data
No. of Combiners | Data Data Data Data
Data Data
Radiation Center | Data Data Data Data
Data Data

I don't see how I can do this using subforms

 

[Bruno Laurans]

Jskkjcs;jxk


Le 28/03/08 20:36, dans (e-mail address removed),

 

[John W. Vinson]

I have a form with a lot of controls on it. I have 9 tables that I need
to use as the control source for this form. On the form I have a Tab control
with 4 Pages and each page contains about 200 textboxes and labels. The
parent form also contains about 100 textboxes, labels and commad buttons.
The controlas on the main form are all bounded to 1 of the nine tables.
The other eight tables have data that needs to go on the TabCtrl Pages. Each
of the other table is about 80 coulmns long.
I tried to create a query so that I can use it as the Record Source of
the form but I am get a "Too many fields defined" error. Is there another way
to do this without put all the fields into one query and still be able to
bound the form controls to their respective tables.

WHOA!!! Slam on the brakes NOW.

If you have 800 fields on your form two things are certain: you'll never be
able to have one query or one form that will be updateable; and more
importantly your database is designed INCORRECTLY. 60 fields is *enormously*
wide for a table.

It's all about the data. What are these tables? What real-life Entity does
each table represent? What are the fields in the tables? How are the tables
related?

You may be starting with the Form - if so, that's like assembling your new
house's roof and walls and windowframes and then later deciding where to pour
the foundation. Get the tables FIRST and then fit the forms to them - not vice
versa!