I wanted to create a database that enable me to characterise bank transactions for tax purposes.
The process is, get transactions from my various bank accounts into tblImport and then selectively add them to tblAccountTransactions. I then review each transaction and characterise is as say something that should be in tblRental or tblDividends.
I am now getting to the stage where things are getting complicated and before I proceed would appreciate if anyone felt inclined to take a quick look at the relationships and advise whether there are any glaring faults.
I believe the weird characteristic with this is that tblAccountTransactions is a reference table and therefore all the details comes from the bank (via tblImport) without any regard to Normalisation.
Any suggestions? Thanks for your time.