2. PHPRunner General questions
  3. [SOLVED]  Combo box lookup from 2 tables
This topic is locked
[SOLVED]

 Combo box lookup from 2 tables

 		10/25/2009 11:54:22 PM
PHPRunner General questions
R
 ragrim author

Hi, im trying to populate a combo box with some data and its kind of hard to explain. basically i have 3 tables, Shows, Members, Userinfo... in shows i have a presentor and i want the lookup to display the name of the presenter from the userinfo, that easy enough but i need it to only select users who are members. due to the nature of the database its pretty poorly designed but its the best i could do with what i have.
Below is the table relationship, i want the presenter combo box to display the Names of the members in the member numbers table.. reason i cant link it directly to the user table is because not all of them are members/presentors.
Shows Table MemberNumbersTable UserInfoTable

Presenter ID -------> MemberNumber

FKUserID ----------------> UserID

FirstName

LastName
Any help on this would be muchly appreciated.
J
 		Jane 10/26/2009

Hi,
you can create view in the database and join userinfo and Members tables for this view, then use this view as lookup table in PHPRunner.
R
 		ragrim author 10/26/2009

Views dont show up in the lookup fields, only the raw tables.
Sergey Kornilov admin 10/27/2009

Regrim,
View needs to be created right in your database.
If you use MySQL check this link:

http://dev.mysql.com/doc/refman/5.0/en/create-view.html