This topic is locked

adding parent and child from same page

2/2/2009 8:48:07 PM
PHPRunner General questions
S
sawanr author

Hi,
I know this question might be posted earlier, but could not find it.
I want to enter parent and single or multiple child records from same page.
Here is the scenario :
I am creating a phone order page, where customer calls and admin enters customer billing details 1st, and then ask for product ID's to order, which he enters on same page. But 1 order can have more than 1 products ordered. So adding 1 parent and corresponding multiple child records would be a big HIT.
I have some more queries, but this is the most IMP one.
Thank you for your reply in advance.
Regards,

Sawan

T
thesofa 2/3/2009

you need to add the order first, then having the orders table linked to the orderlines table as master chils, click the link to the order lines table, then use inline add to add the orderlines, it works almost as fast as the way you suggest and it saves all the custom coding that would be involved.

I have done exactly that for the order system we use here.

S
sawanr author 2/3/2009

you need to add the order first, then having the orders table linked to the orderlines table as master chils, click the link to the order lines table, then use inline add to add the orderlines, it works almost as fast as the way you suggest and it saves all the custom coding that would be involved.

I have done exactly that for the order system we use here.


Thanks for the reply. But I don't mind doing as much as custom coding... I am trying to find a logic on how to do it.
In my actual scenario I have about 5-6 different child tables, so doing it from 1 page is IMP, and is also good from usability point of view.
Regards

Sawan

T
thesofa 2/3/2009

publish the tables and relationships or send me the mysql dump and i will look at it

J
Jane 2/3/2009
S
sawanr author 2/3/2009

Hi,

please check this thread:

http://www.asprunner.com/forums/index.php?showtopic=9360


Thanks for the response Jane. I will be doing custom coding...
May be this feature can be considered as part of wishlist for future runner versions!
Thanks again,

Sawan