adding fields in form

  • Thread starter Thread starter Neo
  • Start date Start date
N

Neo

Hi,

I am having a problem in Access 2002 and was wondering if
anyone came across it. I have a table that requires more
than 255 fields and because Access does not allow this, I
created two tables of about 200 fields in them. Now, the
problem is when I design a form I need fields from both
these tables. I tried creating sub-forms but it slows the
speed of the computer as we have thousands of data.

Do you know if there is a way to include fields from
different tables into a form without using sub-forms? Or
if there are any add-ins for this?


My experience with Access is reasonable but I am not
familiar with coding yet. Any help will be highly
appreciated. Thanks
 
Neo, you may be aware that the real problem is you are using a
non-normalized data stucture.

The is no way that you should have even 100 fields in your table. Where you
have repeating fields (Week1, Week2, ...) they need to be broken out into a
related table. If you can't see where to do this, run the analyzer over your
table (Tools | Analyzer | Table).
 
Back
Top