Lookup wizard with 2 keys

Hi,
PHPRunner doesn't support multiple keys for Lookup wizard. To tell the truth I have no idea on how this can be useful.

Maybe dependent dropdowns feature will help you.

You can describe your project and I'll try to help you to setup it.
Date search should work fine.

Just make sure that you use DATE or DATETIME column type for your date field and that you enter dates into "Search for" box in your local format. I.e. 12/15/2005, not 2005-12-15

Hi here is an example:
CREATE TABLE `ARcustomerTaxes` (

`Id` int(11) NOT NULL auto_increment,

`BusinessUnit` varchar(5) default NULL,

`CustomerNumber` int(11) unsigned default NULL,

`taxCode` varchar(16) default NULL,

PRIMARY KEY (`Id`)

) TYPE=MyISAM;
This the table we want to use. We want to have phprunner use the table above, but to get "customer name" from a lookup table:
CREATE TABLE `ARcustomer` (

`Id` int(11) NOT NULL auto_increment,

`BusinessUnit` varchar(5) NOT NULL default '',

`CustomerNumber` int(9) unsigned NOT NULL default '0',

`name` varchar(64) default NULL,

...

PRIMARY KEY (`Id`),

UNIQUE KEY `BusinessUnit` (`BusinessUnit`,`CustomerNumber`)

) TYPE=MyISAM;
Unfortunately as you can see to get "name" we need BusinessUnit AND CustomerNumber. We can't easily add "Id" which would solve the problem.
Thanks - Steve

Hi,

Steve,
you can use dependent dropdowns for this.
Choose ARcustomerTaxes table in PHPRunner and proceed to Formattingtab.

Select Edit type Lookup wizardfor BusinessUnit field.

Choose ARcustomeras a lookup table, BusinessUnit as Linkand Displayfield.

Check off Unique valuescheckbox.
Then select Edit type Lookup wizardfor CustomerNumber field.

Choose ARcustomeras a lookup table, CustomerNumber as Linkand Displayfield.

Then check off "This dropdown is dependent on..."and select BusinessUnit as Category controland Category field.

Thanks, worked perfectly. I was never able to get the dependent drop downs working before, looks fine now.

Steve,