Hi!
You can use the SQL SELECT statement as a row source of the combobox, for example:
Select a.*, b.* from a inner join b on a.KeyField=b.KeyField into cursor ComboCursor
Or just prepare such cursor and than display it.
Or populate combobox manually using its AddItem or AddListItem methods in a scan loop.
HTH.
>I have two tables with a common field. I want a combo box to display the combined contents of these two table fields. Please help.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.