Problems updating record in two tables

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

Guest

Hi All,
I am having problems and need some help!

I am working in an .adp front end to SQL server.
I have two tables, Test and Test2

Test contains data on individual items defined by an ID that is the primary
key. This table is full of data.

Test2 will contain additional data on the same items, and has a primary key
that is the same ID as in the first table. This table is almost empty.

If a create a query

SELECT Test.ID, Test.data1, Test2.MoreData
FROM Test LEFT OUTER JOIN
Test2 ON Test.ID = Test2.ID

Then create a form based on this query, I can not add/change data in
MoreData unless ID is already in the Test2 table.... I get a write conflict
error when I move to another record "This record has been changed by another
user since you started editing it..." I really need for this form to create
the new record in Test2 with the ID from Test if the record is not already
there.
In an acces .mdb database this works just fine with no additional code
needed. What can I do to make this happen?

Thanks!
Tettnanger

ps. The reason for this ... the situation is much larger than the example...
the Test side of the database imports nightly and overwrites any changes. I
need to track additional data on the Test2 side.
 
No,
Unfortunately I have not yet found a solution. I am moving the primary key
data to the test2 side weekly as new records are created on the test1 side.
At some point I hope to have the time to work on this again.
Tettnanger
 
Back
Top