I have similar but bit different issue that is
I have a table INVOICE when user enter data in invoice I have to insert record into Transactions (Master ) and Transaction_det ails (detail) both the tables have ID type autonumber i have a code that insert into record into Transaction table then when I try to insert record into transaction_det ails record I don't have the trasnsation ID which links these 2 tables. I am using MSaccess...
User Profile
Collapse
-
Creating Master->Details record using Code (Autonumber)
-
I have similar but bit different issue that is
I have a table INVOICE when user enter data in invoice I have to insert record into Transactions (Master ) and Transaction_det ails (detail) both the tables have ID type autonumber i have a VB code that insert into record into Transaction table then when I try to insert record into transaction_det ails record I don't have the trasnsation ID which links these 2 tables. I am using MSaccess...
No activity results to display
Show More
Leave a comment: