comparison the data between access table

[alvinblim]

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

 

[vis781]

This is a forum for VB.Net users. Whilst i'm sure there are people on this forum who would have the knowledge to help you out with your query. Your question would be better suited to a VB forum, there are such forums on the web.