Increasing Number of fields

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

Guest

Hi,

We have a staff database that is continuosly growing. We are constantly
being asked to add new fields. The main form now has 35 fields and the
bosses have requested that we add another date field and a combo box field.

I've gone thru the performance tips I gathered from other links and it does
run much quicker now but I was wondering if there are any other steps I
should take such as adding tabs.

Any advice would be appreciated, many thanks

Ian
 
I would think that 37 fields on a form should not be a problem at all.

Your table structure is important though. You should most likely not have
all 35 fields in one table.
 
Hi,

The majority of the fields are basic personal details so it would be
difficult to seperate them in to a new table. However there are some fields
that I can seperate and create a table of their own.

However I would still like them to be on the main form. Would it be a bad
idea to create a sub form from the main form? However this will only involve
5 fields.
 
Back
Top