Subject 2 details in the sabe grid
Author Andrei Luís
Hi,

I'd like to know if it's possible to do the following in IBO, using
MasterLinks something else, or if I need to do it my self with SQL:

It is a master -> 2 details problem. The problem is that I need to
show the details results in 1 ib_grid only. The detail tables
structures are the same, by the way, it's only 1 detail table with 2
different where clause.

Tables Structures:
Master (customers and bondsman);
rec_id (pk)
name
...

Detail 1(sales by customer)
rec_id (pk)
customer_id
bondsman_id
...

Detail 2(sales with a bondsman)
rec_id(pk)
customer_id
bondsman_id

The customers, could be a bondsman too. So, I need to show in only 1
grid: sales by customer selected in master table + sales that the same
customer is a bondsman.
Today I have two queries, and two grids to show the info. 1 query
masterlinks to customer_id and the other it points to bondsman_id.

The question is, how can I do that?

Hope I was clear, my english is not very good.

Thanks and []s

Andrei

W2K + D4 + FB 1.5.2 + IBO 4.3