2. PHPRunner General questions
  3. presales questions
This topic is locked

presales questions

 		1/12/2008 5:33:36 PM
PHPRunner General questions
J
 josemv author

Hi,
I found today Phprunner and I'm very impressed about its features. Would like to know what is possible and not with this tool. Tried to found answers in documentation and forums but didn't found or didn't understand.
1-A very common issue involves establish relationships between one table and many others. Eg:
domains_table

id

customerId <-- from customers_table

registrarId <-- from registrars_table

salesmanId <-- from salesmen_table

...
How could be defined this relationships with Phprunner? how they are expected to be defined in Mysql tables?
2-For a few items a select field its a good way to allow select the right value, but for many values (eg: customers could be hundreds or thousands) a different approach is needed. We use often a search/selection process from a popup for each field requiring to search within a lot of records.
3-And in you need select multiple related values within many records? Eg a product related with several categories of products.
Thanks

Jose
J
 		Jane 1/14/2008

Jose,
please see my answers below:

  1. sure you can setup master-detail relatioships for these tables on the Datasource tables tab.

    Here is a detailed info:

    http://www.xlinesoft.com/phprunner/docs/li...age_options.htm
    2,3. Use Lookup wizard option for these purposes.

    Proceed to the Visual Editor tab, double click on the field and select Lookup wizard option. To show field as edit box with popup choose Lookup wizard as Edit box with Ajax popup option. To create multiline dropdown change Multiline rows option.
J
 		josemv author 1/19/2008

Hi Jane,
thanks for your reply.
First case its ok, but to use Lookup Wizard as Edit box with Ajax popup, I'm missing something possibly. If choose that option then an empty text field appears, if also check "Allow to add new values on the fly" then a link to add a new value its displayed, but when click on that link opens a new window with an empty text field. I would expect to see some search form and/or list with related values.
Thanks

Jose

Jose,

please see my answers below:

  1. sure you can setup master-detail relatioships for these tables on the Datasource tables tab.

    Here is a detailed info:

    http://www.xlinesoft.com/phprunner/docs/li...age_options.htm
    2,3. Use Lookup wizard option for these purposes.

    Proceed to the Visual Editor tab, double click on the field and select Lookup wizard option. To show field as edit box with popup choose Lookup wizard as Edit box with Ajax popup option. To create multiline dropdown change Multiline rows option.
J
 		Jane 1/22/2008

Hi,
to display field on the add/edit pages as list of values just uncheck Lookup wizard as Edit box with Ajax popup option.