tamara
Posts: 26
|
| Posted: 09/20/2005, 1:20 PM |
|
Hi: I had an Access database that I upsized and imported into SQL. All went well, but some of the data that I have I would like to display with dropdown options. An example of this would be the State field. If there is data in the field already, then I can't use the dropdown because it will not show the data in the field. Is there any way around this? I am sure there is but I am kind of new to this. Thanks for any help, Tamara
|
 |
 |
kevind
Posts: 251
|
| Posted: 09/21/2005, 3:00 PM |
|
Hi there,
is this drop-down in a record form or editable grid ?
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
tamara
Posts: 26
|
| Posted: 09/21/2005, 3:25 PM |
|
I the record form....Sorry, I should have said that!
|
|
|
|
kevind
Posts: 251
|
| Posted: 09/21/2005, 4:15 PM |
|
well, i can't think of a reason that a record having a drop-down field would not show the rest of the list for you to select from
are you sure that you are defining the table that the list of states should be drawn from properly - assuming you're using a table and not a list of values . . . this table should not be in a relation with the record you are editing in the form - if it is then it might limit the list of values once you save or insert it the first time
does that help - let me know
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
tamara
Posts: 26
|
| Posted: 09/21/2005, 4:52 PM |
|
It shows the list. It will not show the state that should be there though, unless I change it to a text box and then it pulls the data from the database.
|
|
|
|
kevind
Posts: 251
|
| Posted: 09/21/2005, 5:38 PM |
|
ok, it sounds like the list box is not bound to the column in the table that contains the state 'id' that you are picking from the list box.
was this all working when it was an access db ?
this should normally work like this:
Table A - let's call this 'contacts' and one of the columns is StateID
Table B - let's call this 'StateValues' it contains column 'ID' and 'StateName'
In the listbox control you want (reading from the top down on the Data Tab, my comments in [ ] )
Name - ListBox1 [or whatever you called it]
Caption - State
Control Source Type - Database Column
Control Source - StateID [this is the column from Contacts]
Connection - your database connection name
Data Source Type - Table/View
Data Source - StateValues [table B]
Bound Column - ID [or your ID field]
Text Column - StateName [or your column name for state]
Data Type - [make sure this matches data type of ID column, a mismatch here can cause these problems - though normally you'll see nothing in the listbox instead]
that should do it - if the table 'contacts' has a stateID that is in the list of table 'statevalues' then, it should show properly in the record without much more effort on your part.
let me know if this helps
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
|
