2. PHPRunner General questions
  3. Difficult question
This topic is locked

Difficult question

 		11/30/2010 4:52:07 AM
PHPRunner General questions
R
 Renex author

Hello,
I have two tables; producten and voorraad.
'producten':

  • product [Xerox Q6003A]
  • barcode [82160412443]
    'voorraad':
  • product
  • barcode
  • aantal
    On the add page from the table 'voorrraad' I have one field called 'barcode'.
    When I type a barcode (82160412443), it must lookup the table 'producten' for this barcode. When it's existing in this table, it must get the "product-title" (product).

    When it has those 2 values, he must insert those values in the table 'voorraad' and count 1 in the field 'aantal'.
    If I repeat this, it must multiply 'aantal' with +1.
    I have tried everything, but can't get it to work.
    Do you have a solution?
Sergey Kornilov admin 11/30/2010

Looks like a job for AfterAdd event code. Need to see your project and database to have a better understanding of how we can help.
I would suggest 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.