Ok. JackDingler and Ron. Am working on it now and i have tables on mysql already.
Here is the link to the tables relationship diagram and some final report:
Image
I am not sure if the tables are properly designed as i was thinking they should all be in one table each record having a parent ID of the other record, and this makes me think how will i load a report like on that image?
any idea how such financial systems are organised and reported?
thanks in advance.