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

Lookup Wizard

 		7/25/2006 4:54:37 PM
PHPRunner General questions
T
 Tubaplayer author

Hi!

I'm testing the PHPRunner, and for a guy like me this is GREAT! I'm still pretty new to php and mysql.
I'm trying to create a sheet music archive database with a user friendly edit interface. PHPRunner makes it a lot easyer than trying to build it from scrathc.
Here's my problem:
I would like to use the Lookup Wizard to create a dropdown menu where the user can select from the composers already in the database - OR add a new one if it's missing. I've got all the fields set up according to description, but of course I might have misunderstood something.
J
 		Jane 7/26/2006

Hi,
use Lookup wizard feature for your purpose.

Select Lookup wizard for your field in the Edit as dropdown box on the Formatting tab (step 7) in the PHPRunner and then setup all required setting.

Here are some helpful tutorials:

PHPRunner tutorials
T
 		Tubaplayer author 7/26/2006

Hi,

Thanks for replying!
I'm already using Lookup wizard, problems are:

  • I'm not getting a dropdown
  • There's no "Add new" link (option is selected in wizard)
    So what I need to find out is what I've done wrong in the setup. In the wizard window:
  • can the link field and the display field be the same?
  • can the link field and the display field be the same as the field used to display the dropdown?
  • or does the link/display fields have to be a different field, or even on a different table?
    If it helps, I'll make a couple of screenshots of the setup I have now when I get home.
    Paal
J
 		Jane 7/26/2006

please zip and send to -[email=support@xlinesoft.com]support@xlinesoft.com[/email] a full set of generated PHP files, your database creation script with sample data.

I'll find what's wrong with your project running it on my test box.
T
 		Tubaplayer author 7/26/2006

Sorry, I realized that as soon as I had put some data into the DB, the fields appeared as expected. Probem solved.