Block on Forms

Hi !

I have one block in Forms displaying 14 records. Three fields are read directly from base table, one is a lookup field. The Post-Query trigger has the following statement:

SELECT cliente INTO :agenda.item_paciente FROM paciente WHERE paciente.id = :agenda.paciente;

It works fine for the first record. Some occurs when using a cursor. In both cases remaining lookup fields are not filled (probably because there is only one active record).

Similar occurs when trying delete records using a checkbox (it is defined on block and it is not a database item) The application should read all check records and delete them. Again, only the first is deleted.

How these issues could be solved ?

Thanks in advance.

-- 
Breno de Avellar Gomes 
Database Applications & Internet Developer

Arquivo-Sistemas de Bases de Dados
P. O. Box 5006
EC Municipio
4017-001 Porto
Portugal

brenogomes_at_ieee.org
Cellular phone: 351-917383469
Cellular messages: 917383469_at_sms.telecel.pt
ICQ # 35567342

Toll free fax and answering machine from USA
1-888-EXCITE2  extension  291-303-8152

Outside USA (international fares apply)
1-917-463-3173