I have two table in my db,
1. Opening table
type
id - autonumber
date - date
Ownerid- number
Nameid - number
debit - number
credit - number
Description - text
2. Bank table
type
id - autonumber
bank - text
date - date
ownerid - number
debit - number
credit - number
nameid- number
narration -...