I think you have not entered the master data ProductID Name 8 ABC InvoiceID Invoice Name 4 ZXZ InvoiceID ProductID Qty Price 4 8 1 0 ----> ok 4 9 4 0 ----> ProductID is not existing 4 10 2 0 ----> ProductID is not existing I think ! This is the problem

There is no need to install MS SAL SERVER on client end. Just provide the Server name at the client in your application server name may be the IP address or the Server name.