2. PHPRunner General questions
  3. drop-down from other tables
This topic is locked

drop-down from other tables

 		8/2/2007 12:36:14 PM
PHPRunner General questions
B
 bueno author

Hi there,
PHPRunner lacks of lookup feature from mutiple tables. Think about this scenario:
I have four tables: countries, teams, players and match_players.
The structure of match_playersis (ID, MatchID, PlayerID)
Now in the match_players Add page, I want to have two drop-down menus and one checked listbox.
One dropdown menu for countries (from countries table)

One dropdown menu for teams (from teams table) that belong to the selected country.

One checked listbox for all players (from players table) that belong to the selected team.
Is this doable by PHPRunner? In CodeCharge this can be easily done because the user can add any contol using the visual editor and then control its properties as he needs but in PHPRunner it's restriced to the fields of the table he's working on.
Thanks for your great efforts developing this software, that makes PHPRunner becomes better and more interesting everyday.
Sergey Kornilov admin 8/2/2007

Bueno,
you must be missing something.
Proceed to the Visual Editor, double-click on field and set Edit as type to Lookup wizard.

Choose the table that populates dropdown box. You can also make dropdown boxes dependent on each other.
B
 		bueno author 8/2/2007

Bueno,

you must be missing something.
Proceed to the Visual Editor, double-click on field and set Edit as type to Lookup wizard.

Choose the table that populates dropdown box. You can also make dropdown boxes dependent on each other.


I already did it.
In my page, I have the following fields:

ID

MatchID

PlayerID
This table does not have CountryIDnor TeamID so, how can I add drop-down menus (Read-only and will be used for filtration)?
Sergey Kornilov admin 8/2/2007

Bueno,
I see what you saying.
If you are a registered user contact me directly at support@xlinesoft.com I'd be glad to help you.