Matrix Layout Screen

[Louis Cohen]

Matrix Layout Screen

I need to generate a Form with a layout like an Oracle Reports matrix
report. The values for each column and row are known, and the user
would enter the data (tyically one value) in each cell. Each cell of
course gets its two parent FK's from the values in its column and row
headers.

I have done this in in Designer 2.1.2/Forms 5 using a temp table with
columns like ROW_VALUE, COL1, VALUE1, COL2, VALUE2, etc. and form
triggers to populate the temp table from the underlying normalized
data during queries, and to go the other way on
inserts/updates/deletes.

In Designer/Forms 9i/10g (to which we are upgrading), can we generate
a Form with a multirecord block in which the records go across/down
like a matrix report?

Thanks