hi
I want to use a datagrid for add,edit and delete record from access relationed tables
i create 3 table
1:
( product ) with fields :
                      PId    PK
                      PDesc     text
2:
( model )  with fields :
                      MId    PK
                      MDesc     text
3:
( ProductModel ) with fields :
                      PMId    PK
                      PMPId     FK
                      PMMId    FK
now i want to do add, delete , edit in ProductModel table.how?
please help me
thanks

Try using INNER JOIN clause to join tables which will bring you with updatable recordset. Altough you could try to populate 3 recordsets, two them should populate comboboxes or some other similar control, so this way you will only need to deal with one recordset

____________________________
If you find the answer helpful, please mark this topic as solved.