dbcombo box using ODBC to SQL 6.5, how to write code properly??
Posted on 1998-07-09
How do I "bind" a dbcombo box to a single field in an SQL table with more than one field? For example, I have a 'Cars' table with 2 fields. The first field is the primary key 'CarID' and the second field is 'Car_Type' (which is unique). I'd like the 'Car_Type' to be displayed in the dbcombo box list. Once selected from the list, the 'Car_Type' text can be captured and the then used in a query on a different table. How do I do this? Currently, the datacontrol works fine and shows the appropriate data in text boxes as I scroll through the records. The dbcombo box of car types should be a static list.