table and form design question

[kelsey]

Hello,
I'm trying to combine two tables into one form, without using subforms. One
table has 255 fields and the second table has about half of that. Is there
any way to merge (or otherwise combine) these two so that I can do data
entry/maintenance on a single form?
Thank you very much,
Kelsey

 

[Larry]

You can create a query that would combine the fields from both tables, and
use your query to power the form. Of course, you need a relationship between
the two tables like Table1.column = Table2.column in order for this to work

 

[Tim Ferguson]

I'm trying to combine two tables into one form, without using
subforms. One table has 255 fields and the second table has about
half of that

Before even thinking about forms, you need to get these tables normalised.
Twenty or so is pretty much the largest number of fields you are likely to
need in a well designed database. I guess you need a lot more tables.

Hope that helps


Tim F

 

[John Vinson]

Hello,
I'm trying to combine two tables into one form, without using subforms. One
table has 255 fields and the second table has about half of that. Is there
any way to merge (or otherwise combine) these two so that I can do data
entry/maintenance on a single form?
Thank you very much,
Kelsey

NO. You can't.

A Query is also limited to an (absurdly huge) 255 fields.

The problem does NOT lie in the query, or your form; the problem lies
in the incorrect normalization of your tables. I've needed as many as
60 fields in a table (over my protests actually) once; 30 is about as
wide as most tables should ever get.

I'm guessing that you have at least one, perhaps several, one-to-many
relationships embedded in each record. Is this a questionnaire or
survey, or what? What are these fields?


John W. Vinson[MVP]