Re: forms question

In article <66mah2$aok$1_at_news.gov.on.ca>,   warren_at_admin.flarc.edu.on.ca wrote:
> In the master block of my form I call a view which contains various
> records with matching id numbers. These records are not actually
> duplicate records as someof the fields (not specifically called by the
> form) do not match. I do not want both records to come up.
> When run the statement select min(rowid),employee_id
> from view group by employee_id
> in sql I get the correct result. One of every record, but when I try
> to run this in forms at the block level it gives me only one record...
> where (rowid,employee_id) in (select min(rowid),employee_id
> from view....etc
> Does anyone have any ideas to get on of these records up only, as well
> as all the single records?

I think the easiest way is to create another view that returns unique values: create view myview2 as Select col1,col2,col3... from myview1 group by col1,col2,col3...;

Then use the view as the base-table for your master block.

HTH,
Steve Cosner
http://members.aol.com/stevec5088 -- Downloadable Forms utility

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet