putting data into multiple tables

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

Guest

Using Access 2002 and would like to enter data into form which will then send
to fields in multiple tables and update them.
Can this be done and how
need basic explanation
 
Hi

Yes it is. One method is to create a query - make sure the data loads as
you need it. If it does create a from based on the query.
 
Thanks Wayne
Have tried to do that but seem to be doing something wrong, not sure if me
or program.
get to form but unable to enter anything into it
What I want to do is put all information onto one sheet then program puts it
into all other sheets into the appropriate fields. I might need "Access for
Dummies" lol.
 
Why do you want to send the data to different Tables?
If The Tables all belong to the same Database. ie you're not dealing with
different back-end systems, you probably have a serious normalization
problem.
Data should normally only have to be in one table in a relational database.

Pieter
 
No just has the field names there and no record areas to input data
Sorry you have lost me with that.

In this case it may be an idea to speak to someone who knows a little about
access and ask them to look at it for you. (I know thats not what you want
to hear)

Just as a thought - try this
Close all the forms/querys/etc. Select one of the tables and use the wizard
to create the form/query for you. Worth a try.

I can't see what your DB looks like so I am not really much use here in this
case. Some one else may post in with a better answer for you.
 
Using Access 2002 and would like to enter data into form which will then send
to fields in multiple tables and update them.
Can this be done and how
need basic explanation
Click to expand...

If you're storing the same data in multiple tables - *your table design is
WRONG*.

Storing data redundantly (i.e. storing multiple copies of the same
information) is just what relational databases are designed to *prevent*.

Read up on data normalization and basic database design in:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

and post back (if the question is still relevant) with details of what these
tables are and what you're trying to store in them.

John W. Vinson [MVP]
 
Back
Top