Forms 4.5 Question

Hello.

I am trying to determine how to do something, but I'm not sure if it is possible. I need to display data from two tables. The first table needs to have it's data displayed one row at a time. The second table needs to have it's data displayed 5 rows at a time, and the rows that are displayed correspond to the row that is currently in view from the first table. The problem is that I cannot show multiple copies of the same data in the second table. The rows of data in the table are not unique, but the one field from this table that I need to show should not repeat any value. Any idea how I would do this?

I was able to create the following query in SQL-Plus, and it returned only unique values. However, when I take the where statement (w/o the where) and put it into the where clause of the block, nothing is ever returned. Here is a modified version:

Select col_a from this_table where rowid in (select min(rowid) from this_table t
 where t.col_a = this_table.col_a)

I have also tried to use a post query trigger on the master block that said:
select unique col_a
into :this_block.col_a
from this_table
where col_b = :master_block.fielda and
col_c = :master_block.fieldb

However, this gives me an error if I try to return more than one piece of information.

Any ideas? They are greatly appreciated.

Thanks,
KRM Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 10 2000 - 13:53:39 CST