I have a drop down data window that returns multiple rows. I need to hide or protect some of the rows that have been returned. I know that if I wanted to protect a column that is easily done in the properties of the column, but in my case here I only want to weed out specific rows. Can I do this on a filter in some way? I need to display these rows on initial retrieve, but then I do not want the user to be able to select them going forward.
What I want to do is hide or protect any rows where my effective date is not the max effective date on the table for a specific customer.
Any help would be greatly appreciated.
Here is my select statement on the drop down data window:
select Distinct dbo.tcu_cust.cust_name ,
FROM dbo.tcu_cust with (index ( i_cust_01)), dbo.tcu_cust_addr_seq, dbo.tcu_cust_address
WHERE ( dbo.tcu_cust.cust_id = dbo.tcu_cust_addr_seq.cust_id )
and ( dbo.tcu_cust_addr_seq.cust_id = dbo.tcu_cust_address.cust_id )
and ( dbo.tcu_cust_addr_seq.address_seq_nbr = dbo.tcu_cust_address.address_seq_nbr )
and ( dbo.tcu_cust_addr_seq.ship_to_addr = 'Y' )
and ( dbo.tcu_cust.cust_type = 'PSOFT' )
and ( dbo.tcu_cust.cust_status >= 'A' and dbo.tcu_cust.cust_status <= 'I' )
and ( ( dbo.tcu_cust.ps_corp_cust_id
in (select dbo.tcu_cust.ps_cust_id
where dbo.tcu_cust.cust_id = :ai_cust_id))
or ( dbo.tcu_cust.cust_id = :ai_cust_id )
or ( dbo.tcu_cust.ps_cust_id
in (select dbo.tcu_cust_add_relations.ps_site_id
where dbo.tcu_cust_add_relations.cust_id = :ai_cust_id)))
and ( dbo.tcu_cust.ship_to_flg = 'Y' )