Sub report vs. sub form - collecting data from multiple tables???

[Kingbenny]

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

[June7]

Why does 'a lot of information' call for multiple tables?

It looks like you have designed the tables after the workbook spreadsheets which might/might not be relational in structure.

What is the primary key/foreign key relationships of these tables?

Want to provide db for analysis? Follow instructions at bottom of my post.

Here are some more tutorials, review the 'sticky' threads at http://forums.aspfree.com/microsoft-access-help-18/