[SOLVED]  displaying data from table

This topic is locked

[SOLVED] displaying data from table	2/6/2010 11:56:02 AM
PHPRunner General questions
N Nucleus author Hi, I have 2 tables. "employees" and "employers". When adding a new employee, I have a drop down menu getting all the names from the employers table, so that when saving the new employee, he will have an employer. This is easy to do, under "Edit as" -> "Lookup Wizard" Now, when displaying an employer I need to show the list of employees that are assigned under that employer. Is there an easy way to do this? Thanks


	Sergey Kornilov admin 2/8/2010
	The easiest way is to link Employees and Employers as Master-Details. This way on the list page you can display the list of employees by employer in popup or in inline preview mode.