2. PHPRunner General questions
  3. Lookup tables
This topic is locked

Lookup tables

 		1/15/2007 8:08:52 AM
PHPRunner General questions
N
 Norian author

Hello,
I have a 3 tables: tickets, company & users.
When entering data into the ticket table I have a lookup for the company name which looks up the company names from the company table.
This works fine, however what I would like to do is then create a lookup for the user. But instead of seeing all users in the user table only see the users where the company name thats been selected in the ticket table = company name of the user.
I have tried using the where option but cannot seem to get the syntax right...??
Many thanks.
J
 		Jane 1/15/2007

Norian,
you can do it using This dropdown is dependent on option on the "Edit as" settings dialog on the Visual Editor tab.

Here is the "How to setup dependent dropdown boxes on Edit/Add pages" flash tutorial:

http://www.xlinesoft.com/phprunner/php-database.htm#
N
 		Norian author 1/15/2007

Norian,

you can do it using This dropdown is dependent on option on the "Edit as" settings dialog on the Visual Editor tab.

Here is the "How to setup dependent dropdown boxes on Edit/Add pages" flash tutorial:

http://www.xlinesoft.com/phprunner/php-database.htm#


Fantastic a nice easy way to do it.. Thank you for the great support