From: "Lester Caine" <lester@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, May 23, 2005 8:05 AM
Subject: Re: [IBO] How would I go about making a grid show this
classification
[snip]

>> Now, I want to show the classifications on a window with the customer
>> data
>> (a grid or a list). I was able to do the master-detail stuff with the
>> samples, as well as lookups, but this one I couldn't figure out myself.
>> Could someone point me to some document explaining how to do this, or
>> better
>> yet, is there a sample available? If my explanation wasn't clear, let me
>> know and I'll try to make more sense ;-)
>
> Sounds more like an SQL problem than IBO?
>
> The detail query is :-
> SELECT T.classification_title FROM classification T
> JOIN classification_link L ON T.classification_id = L.classification_id
> WHERE L.customer_id = :CU_ID
>
> Link :CU_ID to the master record
>
> --
> Lester Caine

Lester,


thank you, I don't know why I didn't notice your message until now, but it
helped - it's working just as I wanted now. Nice and smooth :-)


Antti Kurenniemi