Add grid to center of canvas section

[avianmanagement]

I want to add a small grid not full page width to a canvas sections, similar to the one in the image below:



The only grid control I seem to be able to drag and drop wants it's own section.

How can one do this?

David

[barrymavin]

Hi David

Use a TreeGrid.

[avianmanagement]

Thanks Barry I'll take a look at that

[avianmanagement]

Hi Barry,

I can set the headers for the columns in that, but there does not seem to be an attribute to set the data source for it



How does on set the data source field for each of the columns created in the header labels attribute

List items says it's a list of choices which sounds like a pick list.

David

[barrymavin]

Hi David,

"List items"

e.g.

select * from tablename

[avianmanagement]

Thank you.

I looked through the documentation but was unable to find anything using search List items.

David

[barrymavin]

All choicelists can take a sql select

use {macros} ton the where clause if you need to restrict what is selected.

[avianmanagement]

Thanks Barry,

I'm just looking at the where clause now and trying to figure out how to do that.

page1.section1 is the egg
page1.section2 is the egg weights that the treegrid is on.

This looks really good, once I figure it out.

David

[barrymavin]

Any SELECT statement can have dynamic WHERE condition e.g

SELECT * FROM table WHERE egg = {table.value}

You will need to refresh() the TreeGrid formitem.

[avianmanagement]

Brilliant thank you, I had been looking for some reference to the section rather then just a straight table.filed solution, very neat.

Do you do the refresh of the treegrid of the change delegate of the section it is on or section one which contains the parent data?