Select show multiple row of record in form

Applications Forms
#1

Guys, need help.

I have table for :

  • sales_order_header,
  • sales_order_detail,
  • sales_return_header,
  • sales_return_detail

I have made my form for sales order, and it work perfectly like i want. The problem come when i want to reference the data when built the form for sales_return.

When i load the sales_return form (master / detail), i want my detail generate the data from sales_order_detail table and can be edited before i submit it row by row or all at once.

Does anybody know how to do this ? Or can scriptcase do something like this ?

The purpose so the user doesn’t need to add row by row the data that need to be submitted.

Thanks

#2

It’s a bit cryptic for me but perhaps this is putting you on the right track. WIthin a grid you can create a checkbox and checkall box to select records for processing. I’m not sure if you can create an application link to this grid too so you can update the necessary items, but you can always add an image link to it. How to do it can be found here:

http://www.scriptcase.net/scriptcase-samples/tutoriais/grid/grid44.php

But again, I’m not sure if I understand what you want well enough. Hope it helps.

#3

Hmmm…thanks for the reference. That mean you suggest to use grid as the detail form ? The problem is when you want to edit certain field.

Example :

Sales_order_detail :

  • item. | qty
  • A. |. 10
  • B. |. 15
  • C. |. 20

Sales_return_detail were generate data from sales_order_detail but i can edit the {qty}, add new row, or delete existing row

#4

Anyone can help me please ?