So I have multiple tables where I might need to run reports from information from all these tables. Besides building table relationships, is there a way to pull information from various tables for a report?
... only if you are a programmer and want to write you own code as to how this data relates to each other. Otherwise, you need to have Relationships. ie, there is no such ting as a =VLOOKUP( ) or a =SUMIF( )like Excel has. That concept in QuickBase is done with Relationships.
as above, but you can create report link fields which will enable you to display reports from other tables within your form without a table relationship, however you cannot perform any math across the tables it is limited to the table in which the data shown on the report is held. Its purely for viewing.