display multiple records in control block's text item
431188Oct 14 2004 — edited Apr 4 2005Hi
I am trying to display many distinct records, from a post-query trigger, into a non-database item in a control block.
My situation is as follows :
I have a form based on one database table. This table has a FK link to another table on the column Prov_ID. To insert records into my table , I have created a LOV which does a select on the seperate table that is referenced by my FK. This then populates the FK column in my form-based table with the correct value.
For display purposes , I have created a control block which I have linked to the LOV, so that when users select a value from the LOV , the description displays in the control block's item , and the Prov_ID column gets populated in the background.
My problem lies with querying after inserting records into this form.
Although I am able to query records when i specify some query criteria, I am not able to retrieve all the records when I query with no search criteria.
I have tried creating a post-query trigger to populate my control block's display item with the correct value , but this does not work when i am searching for all records.
Any suggestions.....?