Need an advise in designing DataWindow

[Negator]

Hello all PowerBuilder wizards!

I need an advise on designing dw. I'm just beginner, and these design tools are to huge to understand their abilities quick

I have a table with columns ID and Value. Looks like this:

1 10.11
1 11.05
1 09.15
2 16.13
2 15.98
2 16.25

e.t.c.

My datawindow must have two elements:

1) DropDownList with ID's (no repeats). For this example - numbers 1 and 2.

2) A table with values for the ID chosen in DropDownList.


I'll be pleasant for each advise!
Thank you!!!

 

[pgaec]

Right, lets assume that ur table is called negator
and has the following data
ID VALUE
------------
1 10.11
1 11.05
1 09.15
2 16.13
2 15.98

1. Create a new datawindow with the following SQL
SELECT distinct id FROM
negator ORDER BY id
Call this datawindow dddw_id

2. Create a new datawindow with the following SQL
SELECT id,value FROM
negator ORDER BY id,value

Now in the design view, right click and select properties of
the column "id".
Change the Edit Style from "Edit" to "DropdownDatawindow"
Select "dddw_id" as dropdown datawindow , Data column and Display column both - id
Select "Always show arrow"

There you go....rock on!!!

cheers
MM