G
Guest
I don't know if there is a solution to this question.
Situation:
With MS Access I made a database. In table 1 I have a column MainID that is
the a primary key. This column uses autonummering. This means that the
nummering is taken care of without me writing any code. In table 2 I also
have a column called MainID that is a foreigner key.
The problem:
When I create a 2 new rows 1 in each table and I fill in the data except the
columns MainID I dont do anything with those two. After calling the statement
OleDbAdapter.Update() the database is updated. But when I look in the
database the MainID in table 1 has a new nummer but the MainID in table 2
doesn't have any nummer. What do I need to do to get the MainID in table 2
to get the same nummer as in table 1 MainID.
As stated above maybe this is not possible.
Bardo
Situation:
With MS Access I made a database. In table 1 I have a column MainID that is
the a primary key. This column uses autonummering. This means that the
nummering is taken care of without me writing any code. In table 2 I also
have a column called MainID that is a foreigner key.
The problem:
When I create a 2 new rows 1 in each table and I fill in the data except the
columns MainID I dont do anything with those two. After calling the statement
OleDbAdapter.Update() the database is updated. But when I look in the
database the MainID in table 1 has a new nummer but the MainID in table 2
doesn't have any nummer. What do I need to do to get the MainID in table 2
to get the same nummer as in table 1 MainID.
As stated above maybe this is not possible.
Bardo