Helen:

by this, I don't think Rik needs a master/detail, but a simple join.

Rik:

Did you try in you sql something like:

select D.WhateverYouWant,
M.CLIENT
FROM TABLE_DETAIL
JOIN TABLE_MASTER ON D.MASTER=M.SomeId

Regards,

Artur

----- Original Message -----
From: Rik
To: IBObjects@yahoogroups.com
Sent: Wednesday, August 22, 2001 10:35 AM
Subject: RE: [IBO] problem


yes, but it isn't really a 'master' record but it's the only record that
contains the clientnumber. The 'detail'-records doesn't.

-----Oorspronkelijk bericht-----
Van: Artur Anjos [mailto:arsoft@...]
Verzonden: woensdag 22 augustus 2001 11:11
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] problem


You have master records and detail records on the same table?
----- Original Message -----
From: Rik
To: IBObjects@yahoogroups.com
Sent: Wednesday, August 22, 2001 10:01 AM
Subject: [IBO] problem


Hi,

I am using IBO Version 3.4.Cm

in a table I have a 'master' record and 'detail-records'. In the master
record I have the number of my client.

Now I need to show the records concerning a specifiek clientnumber in an
IBO-grid. If I do so, I
have only my 'master' record off course.

Who can I do this ?


Tanks.





Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]