alvinblim
Well-known member
hi,
i need to using vb6 to write the program.
i have 2 table (tablename = dnentry and salesItem)
dnentry table field = (docNo,proNo , packNo, Qty , address) red color is primary key
salesItem table field =( INV,ProductNo,PackNo , price , dateEntry)
docNo = INV , ProductNo = proNo , packNo = PackNo
i want to check table dnentry data is already have in table salesItem or not. then print all the data that salesItem dont have.
my salesItem table cant have same data inside.
i hope someone can help me solve the problem.
Thank you
i need to using vb6 to write the program.
i have 2 table (tablename = dnentry and salesItem)
dnentry table field = (docNo,proNo , packNo, Qty , address) red color is primary key
salesItem table field =( INV,ProductNo,PackNo , price , dateEntry)
docNo = INV , ProductNo = proNo , packNo = PackNo
i want to check table dnentry data is already have in table salesItem or not. then print all the data that salesItem dont have.
my salesItem table cant have same data inside.
i hope someone can help me solve the problem.
Thank you