I have different types of investments (eg: gold, land, fix deposit, savings bank, mutual fund etc...) all having different information, how to make tables and relate each other so that I could get one brief report as well as breakup reports.
I have different types of investments (eg: gold, land, fix deposit, savings bank, mutual fund etc...) all having different information, how to make tables and relate each other so that I could get one brief report as well as breakup reports.
You don't need separate tAbles for gold, land,etc.
it should be 1 table , tProperty.
the records would be,
gold
land
diamonds
a table for tBanks
a table for items in the bank, tBankAccts
The acct records,
checking
mutual fund
etc
I would suggest you do some reading about database design and normalization.
"Old Programmer's Rule" is this: If you can't do it on paper then you can't do it in Access. Until you can draw out your tables AND rules for how they change for each function you want to perform, you are going nowhere fast.
Fundamentals of Relational Database Design
http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf
Database Design Basics
Entity-Relationship Diagramming: Part I,
http://rogersaccessblog.blogspot.com...ng-part-i.html
Normalization Parts I, II, III, IV, and V,
http://rogersaccessblog.blogspot.ca/...on-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html
Here is a link to some youtube videos you should watch:
https://www.accessforums.net/showthread.php?t=62566
See Post #3