table and form design question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
Click to expand...

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
 
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
Click to expand...

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]
 
Back
Top