my data is like this

1st table VoucherMaster

VoucherTypeCode---VoucherNo-----VoucherDate----Narration

JV----------------13140001------2013-03-26-----Sale Summary Closed.

JV----------------13140002------2013-03-26-----Sale Summary Closed.

JV----------------13140003------2013-03-28-----Stock Transfer

JV----------------13140004------2013-03-28-----Sale Summary Closed.

----------------------------------

2nd table VoucherDetail

VoucherTypeCode----VoucherNo

PU-----------------13140001

PU-----------------13140001

PU-----------------13140001

PU-----------------13140002

PU-----------------13140002

------------------------------------

3rd table VoucherType

VoucherTypeCode-----VoucherType

JV------------------ADVANCE VOUCHER

BP------------------BANK PAYEMENT VOUCHER

JV------------------BANK RECEIVED VOUCHER

PU------------------Client Order

CP------------------CASH PAYMENT VOUCHER

thanks for the help