Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 12th, 2004, 05:20 AM
Registered User
 
Join Date: Jul 2004
Location: Bristol, , United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inserting data from forms

Hey,

I am trying to save data from a form to multiple tables in the database. I set up the relationships using the relationship diagram in Access 97 but it is not picking up the fields within the table that I need to save, I know I am missing something...

I am not sure how to format the SQL to insert the data from the form into the database, can someone please give me some guidance?

Thanks Very Much



Sarah
 
Old July 12th, 2004, 07:05 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Can you paste the code?



Om Prakash
 
Old July 12th, 2004, 08:17 AM
Registered User
 
Join Date: Jul 2004
Location: Bristol, , United Kingdom.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

SELECT Address.AddressName, Problem.[Problem ID], Problem.ProblemDescription, Problem.ProblemSolution, CustomerDetails.CustomerName, CustomerDetails.PostTally, CustomerDetails.StaffNumber, CustomerDetails.NTNumber, CustomerDetails.ContactNumber
FROM CustomerDetails INNER JOIN (Address INNER JOIN Problem ON Address.AddressID = Problem.AddressID) ON CustomerDetails.CustomerID = Problem.CustomerID;

this is the select statement that was generated by Access yet still I cannot enter information into two fields which are problemDescription and problemSolution, would a different type of join enable me to input data?

Thanks Again

Sarah
 
Old July 12th, 2004, 08:45 AM
Friend of Wrox
Points: 2,473, Level: 20
Points: 2,473, Level: 20 Points: 2,473, Level: 20 Points: 2,473, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2004
Location: India
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

I think you need to insert data by seperate queries.

One query to insert data in CustomerDetails and second one in problem table.

Om Prakash




Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting data stevens ADO.NET 0 May 13th, 2008 07:49 AM
Data inserting twice nuttylife2 ASP.NET 2.0 Professional 8 August 22nd, 2006 11:01 AM
Inserting data when data already exsist desireemm SQL Language 0 January 16th, 2006 11:01 PM
Inserting dates in forms zulf Dreamweaver (all versions) 2 November 22nd, 2004 02:20 PM
Inserting forms fields into Access tsparker Classic ASP Databases 1 October 9th, 2003 03:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.