title: ASP MVC3 Looping through multiple tables not held within your model
body: <p>I'm new to ASP MVC and have a quick question about accessing data in other tables that aren't part of your @model. </p>
  
  <p>Example:</p>
  
  <p>Right now I have two tables, I'll call them table1 and table2.</p>
  
  <p>I pass table1 out of the controller to the view and then do a foreach loop through that to output its contents.</p>
  
  <p>Within table1 I have a reference to table2 so I can access the fields in table2. What I want is to loop through table2 as well, but I'm unable to do that because the only data that I've output to my model is the contents of table1 so although I can access the data for T2 I can't access information such as how many rows it has.</p>