Save oracle form (data) in database - not standard case - help?
662827Nov 12 2008 — edited Nov 19 2008Thanks a lot. That is exactly what i needed.
OK lets clear the picture.
My situation is a bit not standard and abstract, i hope you could understand me, because my english is pour.
Here is what i want to do exactly.
Imagine i have a personal form with fields first name(text box), last name(text box), gender(radio button), matrial status(list box -> single, married, divorced), Comments(text area), I agree(check box) i.e. all standard input fields (there are forms items for every one of them).
So i need to save the form in the database table, not only the selected data but all the data and to mark in some way the selected data. For example the user chooses married from the list box ->i need to save in the db this form with all choices and the selected choice i.g. married.
When the application starts a form with table with all saved forms is displayed ->user clicks on some form (from the table) and detailed (personal form) is displayed with all the data and the selected data(where it has choices in list box for example).
Could it be done?
I saw in the data layout wizard, that there are tabular and form view so my question is if i choose form view could it contains fields different from text box, list box for example. And how to load data in it and how to understand what data was selected(witch choice).
Best regards.