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

Can you paste the code?



Om Prakash

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

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