Displaying Information from GRANDCHILD Records

Classic Servoy
1

My Schema:
Order Header Table (Has Customer #) related to Order Lines
Order Lines Related to Inventory (Which has the description I want displayed)

When a user signs onto the system, I want to display a list of ALL of their ORDER LINES with the DESCRIPTION from the inventory file. I do NOT want a parent window with the order headers, so if there are 3 rows in the order header and each order has 4 line items, I want a table (or list) display of the 12 rows with the description. Can this be done?

Thanks

Bruce

2

If I read well you have twelve order lines and want to display 12 order lines. How about making a form on the order lines table?

3

Sorry I must not be explaining my problem.

If I make a form on the order lines, there is no filter to limit it to just the current customers order. If my form is tied to the order header, then the only way to display the order lines seems to be either a portal or a tab.

4

I still don’t understand what you are trying to do. By default in Servoy a form shows all rows of a table and there are various ways to get less rows to be shown based on your preferences. For example if you only want rows to be displayed that meet certain criteria you could perform a find on them or use filter functions to limit the foundset. You can also have a form display no rows by default setting the showAllRecordscmd property on a form to None.

5

Sounds like you could just create a self join relationship based on the current order

6

I’m having the same problem.

OrderHeader->OrderLines->ProductDescription

When I click on an OrderHeader record, I want to see all of the ProductDescription records for that header. I do not want to see any of the lines.

7

Minerva:
I’m having the same problem.

OrderHeader->OrderLines->ProductDescription

When I click on an OrderHeader record, I want to see all of the ProductDescription records for that header. I do not want to see any of the lines.

Create a tableview on OrderLines, place related productDescriptions on the tableview, make a tabpanel on orderheader with relation to orderlines, place the created tableview on it.

8

Related question: how would we best get a list of Order Headers with aggreagted values (assuming that the price is in Product Description (arguably not a real-world example, but it illustrates my question)) for an arbitrary foundset of Order Headers?

Also, a sum of the order values over the foundset of Order Headers?

Thanks,
Neale.

9

Neale:
Related question: how would we best get a list of Order Headers with aggreagted values (assuming that the price is in Product Description (arguably not a real-world example, but it illustrates my question)) for an arbitrary foundset of Order Headers?

create a sum in product description, place on listview with order headers, it will aggregate through the relation.

Neale:
Also, a sum of the order values over the foundset of Order Headers?

two options:

  1. make the sum of the above stored and sum on that field
  2. use sql and database manager