View Multiple Records

This topic is locked

View Multiple Records	3/30/2007 2:44:20 PM
ASPRunnerPro General questions
I ignatiousreilly author Hello - I have a table of Companies, each one asigned to a team. I also have a table of Employees, each assigned to one of the same teams. There are several Employees on a team for one company. I have both the Company table and the Employee table reading off the same look-up when assigned to teams. Now when I view a Company, I would like to see what team they are on, and who all the Employees are assigned to that team. I am currently using an 'inner join' on the Company table, but don't know how to get it to view multiple records - so I can see EVERY Employee who has been assigned to their team. Thanks a lot!


	Sergey Kornilov admin 4/3/2007
	As far as I understand you need to display the list of Employees as a readonly info. In this case you can use OnLoad event to achieve this. See sample Event "Show list of customer orders" for an example.