How to display data from table to combo box?

[bluethunder]

Good day everyone,

I'm having a hard time with my program on how to display the data from table to combo box. I have two tables that have been LEFT JOIN to have their relationship in the Data Environment SQL command. My 1st table is expense that has a columns of expno, expenseAmt, purno, acctno and the 2nd table is chartaccounts that has a columns of acctno and acctname.

How can I integrate the data from table to display it in combo box using Data Environment?

Is there any hard code that I must use to run the program?

Need help..

[smartchap]

Dear ur question is not very clear. What data do u want to display in Combo Box? Is it a column of data from a table (out of two) or something else? If u want to display contents of a particular column in a Combo Box, I think, u must use Recordset (say named rs), goto first record, loop through each record with rs.MoveNext upto rs.EOF and add item of that particular field (column) into ComboBox.
If required something else, please make it clear or post ur code with problem being faced.

[bluethunder]

problem solve.

[smartchap]

Good to hear that u have got the solution. If u post ur code, I think it may be of benefit to others.