 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / September 2007putting data into multiple tables
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.  SignatureWayne Manchester, England. > 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 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. > Hi > [quoted text clipped - 5 lines] > > Can this be done and how > > need basic explanation Does it work in the query SignatureWayne Manchester, England. > Thanks Wayne > Have tried to do that but seem to be doing something wrong, not sure if me [quoted text clipped - 13 lines] > > > Can this be done and how > > > need basic explanation No just has the field names there and no record areas to input data > Does it work in the query > [quoted text clipped - 15 lines] > > > > Can this be done and how > > > > need basic explanation > 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. SignatureWayne Manchester, England. > No just has the field names there and no record areas to input data > [quoted text clipped - 17 lines] > > > > > Can this be done and how > > > > > need basic explanation 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 > Thanks Wayne > Have tried to do that but seem to be doing something wrong, not sure if me [quoted text clipped - 16 lines] >> > Can this be done and how >> > need basic explanation >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 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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.