sreejithm
asked on
Auto populating a table in oracle form
Hi ,
I have designed an oracle form that displays post dated cheque details for a sales order. The form has the following details
sales_order_id
payment_id
Installment_no
cheque_number
cheque_date
cheque_amount
receipt_id
My requirement is : When the user enters the first date of the cheque and the number of installments, the net sales amount is obtained from the sales order table, the table above should be populated automatically based on the number of installments. The cheque dates and the amount needs to be populated automatically. We assume that the cheque will be used monthly and the dates needs to be monthly sequentially.
Kindly assist me on how this can be done. An immediate assistance would be highly appreciated. We use forms 10g.
I have designed an oracle form that displays post dated cheque details for a sales order. The form has the following details
sales_order_id
payment_id
Installment_no
cheque_number
cheque_date
cheque_amount
receipt_id
My requirement is : When the user enters the first date of the cheque and the number of installments, the net sales amount is obtained from the sales order table, the table above should be populated automatically based on the number of installments. The cheque dates and the amount needs to be populated automatically. We assume that the cheque will be used monthly and the dates needs to be monthly sequentially.
Kindly assist me on how this can be done. An immediate assistance would be highly appreciated. We use forms 10g.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Markgeer. The user needs to have the flexibility of making adjustment.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I thought that the question was not about creating a new records in a table :).
You can do it this way:
1. create a when-new-block-instance trigger on block "Checque details" and in this trigger an execute_query will perform.
2. in Pre-Query trigger of block "Checque details" you can modify default_where property of block.
In such scenario when an user click on block "Checque details" the block will be populated with records.