>>I kind of supported an Oracle app for a few months, so I did some studying. It was a year or so ago, so I'm trying to remember. But I think that the definition of the data block is that it accesses 1 and only 1 table. I believe you have to define a data block for every distinct data source you want to use.
>Correct, that was what I think was a PITA
Bigtime PITA. If your form accesses several tables, you have to make sure you are in the right data block when you add a new control. Otherwise you won't have access to the correct data source.
As a matter of fact, one of the examples of bad interface design in Developer 2000, is the way they use navigation keys. We generated a quick form. There were the standard nav buttons at the top of the form, <<,<,>,>>. In Oracle the single bracket buttons work the way you expect, nav 1 record at a time. But the dbl brackets, instead of top and bottom are for moving between data blocks.
PF
(On an infant's shirt): Already smarter than Bush