Populate Xdialog Box from Table

[John Castle]

I would like to fill an Xdialog box drop down list with a couple of columns (one numeric and one text) from a table then use the selected result as a filter for filling another Xdialog box drop down list with columns from a second table.

Can this be done without resorting to XBasic?

My searches so far have yielded nothing.

[Keith Hubert]

RE: Populate Xdialog Box from Table

John,

Have you created one dialog box with the data you want? You should be able to use the data as a filter for the second dialog box.

Many moons ago on this forum Cal Locklin posted a very good example of a multi dialog box where the data in one box became a filter for data in another box but all within one screen. It is worth searching for.

Regards

Keith Hubert

Guild Member
London.

[John Castle]

RE: Populate Xdialog Box from Table

Wish I could even get one dialog box to populate with data from a table!

[mronck]

RE: Populate Xdialog Box from Table

Hi John,

You can populate an Xdialog box with data from a table, but NOT if the data is numeric.
As far as I know you can only list data of the Character type.

Regards,

Marcel

[JerryBrightbill]

RE: Populate Xdialog Box from Table

Marcel

Actually, you can populate a list box with numeric fields. The easiest is to use the Record List-List box which will create a keylist that can use any type of field, including dates, numbers, etc

Jerry

[JerryBrightbill]

RE: Populate Xdialog Box from Table

John

Attached is a text file with 2 scripts. One is done all in action scripting and one was created in xbasic using the xdialog genie and editing. Both do about what you describe. To test them, do the following

1. Save the attached file in any folder
2. Open the Alpha Sports sample database
3. Go to the code tab and select import
4. Select the attached file and import both scripts
5. Now you can run the scripts and see the code

Jerry

[John Castle]

RE: Populate Xdialog Box from Table

Thanks for the help!

Even though my variables should be numeric, once I used the record list list box it worked ok and so did the filtering.

Except that is for one issue: when the user looks up the data for selection into the dialog boxes they see 2 columns - an ID No column and a Details column. I can store the ID No for writing to the browse later but it looks like I cannot store the corresponding Details as well. I do not want a second drop down box on the dialog box for the details since selecting the ID No should also select the details. Or do I need to resort to amending the code for this?

[JerryBrightbill]

RE: Populate Xdialog Box from Table

John

Onh your keylist, you can specify an expression instead of a single field as the return value. For example, in the examples I sent, instead of returning using "invoice_no" as the return, you could use the expression

Invoice_Number + "|"+Product_Id

to fill the value of the variable V1. Then to get the invoice number only, this would work

inv_no = substr(Var-"v1,1,at("|",Var-"v1)-1)

to get the value for product_id this would work

prod_id = substr(Var-"v1,at("|",Var-"v1)+1)

I used the pipe character | as the delimiter between the vlaues, but you could use almost any character. The pipe is unlikely to be found in any data, so it is a good choice.

Jerry