Re: LOV and executing a query
Date: 1996/05/17
Message-ID: <4nh072$4l3_at_newsbf02.news.aol.com>#1/1
>I have an LOV which lists names and case numbers. The case number is the
>primary key of my table. I wish to select one of them names from the LOV
>and have it execute a query to display the record related to the case
>number of the name the user selected. Any ideas on how it can be done.
>I havent figured out who to incorporate cursors into my forms 4.5. I
>thought about using a cursor, but for some reason the form thinks I'm
>doing any insert instead of search. It has kinda baffled me
>Any help would be grately appreciated
>Jim
Put your form into enter-query mode upon entry and have the first field that's queryable be the one that contains the case number. Have the list pop-up automatically and once a record is selected, execute the query in a when-new-item-instance trigger on your second queryable field.
I don't know if this is what you're looking for, but hey, I tried! Received on Fri May 17 1996 - 00:00:00 CEST