PC Review


Reply
Thread Tools Rate Thread

Combo box & data set Issues

 
 
Nikolay Petrov
Guest
Posts: n/a
 
      26th Aug 2004
I have a SQL database with two tables: Contacts and Companies
On form where the user should edit the Contact details there is a combo box
from which he can select the contact's company.
I am filling dataset using a strored procedure.
To the moment I have managed to display the name of the company currently
assigned to the contact.
What I want the combo box to display the list of all companies in Companies
table, so he can select to which company the contact belongs.
I don't know two things:
1. How to define the SQL statment in my stored procedure so the Dataset is
filled with all compnanies from the Companies table.
2. How to bind the Combo box to achieve the same

My tables contain these fields:
Table Contacts
ContactID
FirstName
LastName
CompanyID

Table Companies
CompanyID
CompanyName


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combo Box Issues tcb Microsoft Access 3 17th Aug 2006 02:59 AM
Using Combo Boxes to Display Data from Previous Combo Box select? =?Utf-8?B?SmV0aDA4MDg=?= Microsoft Access 1 12th Jun 2006 04:44 PM
combo box issues Francis Microsoft Access 1 19th Jan 2006 11:32 PM
Combo Box Issues =?Utf-8?B?S29qb25lcw==?= Microsoft Access Forms 1 15th Dec 2004 09:21 PM
Combo Box issues Mike DeRemus Microsoft Access Form Coding 3 12th Apr 2004 08:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:42 PM.