What are the ideal Relationships for my MS Access database?
July 10, 2011 6:26 AM Subscribe
MS Access Database Relationship Help. I am relatively new user of MS Access and need to figure out the ideal or proper relationship between the tables I have created for multiple company's financial statements that will provide the most flexibility when viewing and comparing the financial statements.
posted by otto42 to work & money (8 answers total) 1 user marked this as a favorite
Please suggest the ideal "one to one"; "many to one"; "one to many" and "many to many" relationships since you are an expert and I am confused. These are the tables I have. (If I need to add or remove a table, feel free to make a suggestion.)
----Each Company has the following 3 Financial Statements
-----Each Financial Statement has the following 3 Years of data.
*I think my goal is to be able to run a query that shows this all at the same time:
All Companies ______ Statements________2008__2009__2010
Company X__________ -Income_Statement____ Data___Data___Data
Company X___________-Cash_Flow___________ Data___Data___Data
CompanyY =same as above
CompanyZ =same as above