Might have built my DB backwards but here is my problem:
I need to pull data from multiple tables in order to show a "financial summary"
Currently I have: Company; BalanceSheet; Debt; Liabilities; Income
All tables have a lot of information (which is why I built them in multiple tables).
I need to build a form where I can use a combo box to select a company from a list.
Once selected - I need to the form to pull selected information from each of the above tables. (As well as perform some math functions)
I've been struggling with the relationships (They don't seem to make a difference) and I believe I am above and beyond what the wizards will accomplish.
I have read thread after thread but cannot seem to find a specific answer on how to accomplish this.
To make matters more complex - Once finished I want to be able to select multiple companies and create a report from the fields mentioned above (IE: pick company A, B, and C and have all of there "current Assets" add up on one report)
This task was originally achieved using an Excel spreadsheet but it has become to confusing for users and difficult to save information for future use.
I believe all of my fields are constructed correctly - Now I just need to learn how to compile the data from multiple tables into one form/report
Also - first time with a "Forum" in my life so please be patient.