How can my aspx page update 2 tables in mdb which has ID that is linked RRS feed

  • Question

  • User-775831949 posted

    I am given a mdb file with

    TableA of field: ProductKeyID (an Autonumber, PrimaryKey), ProductName.
    TableB: ProductKeyID (only existing KeyID in TableA is allowed), ProductManager, etc

    I am asked to created an aspx file with input ProductName and ProductManager to insert into both TableA and TableB

    My problem is, when I insert ProductName into TableA I have no problem but upon insert into TableB,
    I have to know the ProductKeyID but I do not know how to find it. And I tried to select from TableA after insert into TableA but it is
    not so fast to be available for me to insert into TableB.

    What can I do ?



    Sunday, December 30, 2012 6:22 AM


All replies