Adding records from a form with a query

S

Steve Marsden

have a database with several tables. The main table has an ID field as its
primary key and the other tables all contain extra information and are
linked to this main table also with an ID field as the primary key on a
one-one relationship. I have pulled all the data into one form using a query
created with the wizard using LEFT join. The ID field on the main table is
an Autonumber field.

All this works until I add records. When I add a record a record is added Ok
to the main table. If I enter data into the fields from the other tables,
records are added OK to these as well.

However, if I don't add data to the fields from the other tables, no record
is written to those tables which is OK BUT when I then update that record
later and enter data into the fields of any of the other tables, the record
is written with an ID field of 0 rather than the ID field of the main
record.

Anyone any ideas why?

Thanks
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Adding data to MS Access from csv file 0
Append Crosstab Query to Existing Table 0
Split form 0
Dynamic Naming of Form Button 3
sqlite-odbc write conflict 2
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top