i've created a sql database contains 7 tables.
bankacc
cashpay
customer
opening_balance
payment
receievedchq
withdrawal
and also create three forms for customer, bankacc and payments.
bankacc table : bankid,bankname,branchname,accname,accountno
customer table : custid,custname,custadd,tpno
payments table : paymentid,paymentdate,custname,description,chqno,duedate,accname,amount
in payments forms there are two combo boxes for custname and accname
custname combo should be connected to : customer table custname
accname combo should be connected to : bankacc table accname
and want to pass this all record to payments table in database. I am new to c#. can anyone help with coding.