tabular form no data found error
I want to use a tabular form in a region within another form so that the user can add a list of items affected by the information in the main part of the form. I created a seperate table to hold the values of the tabular form that includes a field for the form number to which the tabular form will refer and will create an LOV for the item/description to handle the select list for the item/description fields . In other words, here's a shortened example of my tables:
MY_MAIN_FORM_TABLE
ECR #
Dept #
Manager Name
MY_TABULAR_FORM_TABLE
ECR #
Item #
Item Description
I will make the tabular form display conditional with a button b/c there will not always be items associated (user will click button when needs to add items). My problem is that when using the Add Row button to start adding items I get the ORA-01403 - Unable to fetch row error because there is nothing yet in the table. I can add a bogus record to the table but I don't think I should have to. Also, I have to figure out how to auto-populate the ECR# field in MY_TABULAR_FORM_TABLE with the ECR# of the associated main form.
Maybe this is not the best way to handle this so if you have other suggestions, I'd love to hear. THANK YOU!