A sample of the problem :
I have 2 tables with a relationship n..n
so this means that the relationship is also generating a table
so what kind of code I can use to do this.
table 1 has the name of the persons :
table 2 has the car that this person have...
Note that I already have the peoples name filled with some records.
first table has a PK let's call
table1_rowid
second table has a PK ... table2_rowid
then the relationship m to n is generating a tbl1_tbl2
where I have two fields table1_rowid and table2_rowid
When I'll add a new record in the table2 for the person that has the
table1.rowid =1
what is the code that I can use to automattically fill the necessary
information in the relationship table tbl1_tbl2??????
No doubt that exist some code to that automattically in the new ado.net or
regular oledb.... objects in the DOTNET???
Any idea, to make my life easier?