This topic is locked

Master-Detail Problem

10/27/2011 5:09:24 AM
PHPRunner General questions
D
direwolf author

I am creating an invoice form which connects to two tables:

  1. Billing
  2. Billing Details

  • Billing consists of the general billing information such as the customer, date, total amount
  • Billing Details consist of the products bought, their quantity

    -- Of course, one invoice can have many different products in it
    My problem:
  • I've created a Billing Master form which has Billing Details form underneath
  • But, how come I can submit a Billing Master form without inputting details for the Billing Details? (even though Billing Details has empty required fields)



    Question: Is there a workaround for this? For the two combined forms to have only 1 Save button?

    Please help! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=18029&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

C
cgphp 10/27/2011

In Table link properties (check tis article: http://xlinesoft.com/phprunner/docs/master_detailes.htm) enable Display child record on Add page.

D
direwolf author 10/27/2011

Yes, I get that. I was able to enable adding details on the add master form.

  • But you see, I was able to save the Master form even without inputting details below...

D
direwolf author 10/27/2011

Help anyone please?
Should I manually customize the code for this to work?

I would really appreciate it if someone can just put me in the right direction.
This is the "key" form for me. After I get pass this, everything should be smooth. I'm actually basing on this form whether I buy PHPRunner or not.
Help! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=61771&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Sergey Kornilov admin 10/27/2011

Some manual coding might required as by default you are allowed to add master record without details.
My suggestion is to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We'll see what we can do.

D
direwolf author 11/1/2011



Some manual coding might required as by default you are allowed to add master record without details.
My suggestion is to post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program. We'll see what we can do.


Hi sir,
I have already uploaded the demo test but it says there that : "Account is awaiting verification. We have sent you the verification instructions to your email address.". I still haven't receive that e-mail.
Anyway, I'll create a ticket for the meantime.
Please check the demo site, I want it to work like a normal invoicing system, where I need to put general info. with details at the same time. Would it be possible with the PHPRunner tool as is? If not, kindly guide me as to what file and where in it should I start editing. I have PHP background. It's just your tool makes things so efficient that I would like to avoid manual intervention in the code whenever I could.
Thanks!