Aargh! HTMLDB is giving me JDeveloper flashbacks!
Having spent a couple of days wrassling with HTMLDB I find I'm in the same predicament. Sure I can build straightforward Create/Edit/Delete pages quite nicely but now I want to build an integrated application and ... it's not easy. The document consists of tutorials and How Tos, which - you know what's coming - don't quite show me how to do what I want to do. The problem is the documentation doesn't seem to be written by people with a lot of experience in writing form-type applications. The two day tutorial doesn't even mention Master-Detail forms, which I would have thought is a fairly basic; even spreadsheets frequently have some header info.
Of course, the HTMLDB forum seems to have a lot more answered posts than I recall the JDeveloper forum got back in the days. OTN has quite a few sample applications, so perhaps I just need to install all of them until I find an example. And there's also blogs. So no doubt the information I need is out there, somewhere. It's just finding it that's going to be the issue. At least I hope so. I've been trying to build an LOV that has its query restricted by an existing value on the page; the resources on the interweb have offered me at least three different implementations , none of which worked the way I wanted.
I'm just stressing out here probably because I'm trying to be too clever too soon. I obviously need to stop being an active user and spend two days going through the tutorials, building applications I don't need, in order to get a handle on the basics. But with a heavy heart I'm afraid I have to tell my project manager to start cranking out the Excel again. It's not going to be as easy to implement his spreadsheet in HTMLDB as I thought. Blast.