How do I create a Form in Access that reads and writes data to mu.

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

Guest

I have an existing company that is growning and my limited database skills
are preventing us from using Access further.

Here's my problem: I cannot figure out how to create a form that pulls data
from multiple tables. I would put all the fields in one table, but Access
limites the total number of fields and we have too many. Currently we have a
form that pulls and allows us to input and update data to one table. I would
like this exact same functionality, except having the one form pull and
update data from 3 different tables.

Any help is much appreciated!!!!
 
I have an existing company that is growning and my limited database skills
are preventing us from using Access further.

Here's my problem: I cannot figure out how to create a form that pulls data
from multiple tables. I would put all the fields in one table, but Access
limites the total number of fields and we have too many. Currently we have a
form that pulls and allows us to input and update data to one table. I would
like this exact same functionality, except having the one form pull and
update data from 3 different tables.

Any help is much appreciated!!!!
Click to expand...

A quick suggestion is to use Subforms... but I VERY strongly suspect
that a deeper inspection of your table structure is warrented.

"All the fields in one table" makes me worry that you have not
properly "normalized" your data. You should have one Table for each
type of Entity (real-life person, thing or event) of importance to
your application; these tables should be in one-to-many relationships
reflecting relationships in the real world. If you're just throwing
more fields into a wider and wider table (or three tables) you're on
the wrong track.

Could you describe your tables, and what they represent in the real
world? Perhaps post some examples of fields in the tables? Starting
with the Form design is a bad idea; get the tables properly structured
first!

John W. Vinson[MVP]
 
Back
Top