Subject | 2 details in the sabe grid |
---|---|
Author | Andrei Luís |
Post date | 2005-10-13T11:46:36Z |
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
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