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 Received on Thu Jun 10 2004 - 13:43:02 CEST