This topic is locked

How to use _add.php in another _add.php page

3/18/2008 12:13:22 PM
PHPRunner General questions
F
Fanta author

Let's assume that we have three tables: Company, Companys-Products and Product which are connected like one to many; One company can have lots of products, and one product can have lots of company's. Because of that we have table Companys-Products.
Now with help of PHPRunner we can easily create pages for view, add, list, edit and lots of another possibilities.
Not let s hold on add pages.
With help of Companys-Products_add.php page I can easily connect one company with her products and easily save them in table Companys-Products.
But, lets say I realize doing that job that I don't have one of the wanted product in my table. That's means that I need to go to Product_list.php page, where I need to click Add new and than throw Product_add.php page I add a new product in my table Product.
But now one big question, is there any way that we can avoid that???
What I mean is this, on page Companys-Products_add.php page I would like to add or have link Product_add.php page. When I realize than the wanted product is not in the list of the procurable products, I just click that link, add a new product and go back to same page (Companys_Products_add.php page) and continue my work with new product on the page.

Sergey Kornilov admin 3/19/2008

You can set 'Edit as' type of Product field to 'Lookup wizard' and enable 'Add on the fly' feature.

F
Fanta author 3/19/2008

You can set 'Edit as' type of Product field to 'Lookup wizard' and enable 'Add on the fly' feature.


I tried to do like you say admin, but let's say this is not exactly what I mean, only part of it. But I notice one thing, so I have idea which maybe you can put this in the next of your version.(I use last stable version.)
As I saw it open a little new window where you can add a new value for some field, but when I click Save it does not close the little window it just erase what was inside of him. Second the value that I add throw fly after saving is not visible in the field that I wanted to add. For me, if the user add a value throw fly he must see her, and be able to work with her after that. The only way to see that value again is to refresh the main page after adding the value in small window which should be closed after saving.

Alexey admin 3/19/2008

Hi,
try to install the latest update of PHPRunner 4.2 (build 358) and rebuild your project.

If this doesn't help please publish your project on Demo Account (last tab in PHPRunner) and send a URL where I can see and troubleshoot this problem to support@xlinesoft.com

F
Fanta author 3/19/2008

I was try before to publish my project on Demo Account, he pull my pages, but Demo Account did not pull my database. Database is MSSQL.

Alexey admin 3/19/2008

Hi,
please make some screenshots that describe the issue you having with Add on the fly and send them to support@xlinesoft.com