Tim Morrison
|
Posted: 04/03/2003, 1:30 PM |
|
I have 2 tables Countries and States
Countries
CountryID
CountryName
States
StateID
StateName
CountryID
In my editable grid - how to I create a drop down list showing my countries
(just need to show country name, not the ID)
My Grid is like this:
State Name CountryID
(Text) (Drop List)
I want the drop list to display countries from my country table.
Should be easy, but ive never done it.
TIA
Tim Morrison
|
|
|
Brian Gubb
|
Posted: 04/03/2003, 9:27 PM |
|
Just right click on the text box in the editable grid and change it to a
listbox. In the properties for the list box select the table you require and
the field to return.
Brian
"Tim Morrison" <sales@kjmsoftware.com> wrote in message
news:b6i959$bvd$1@news.codecharge.com...
> I have 2 tables Countries and States
>
> Countries
> CountryID
> CountryName
>
> States
> StateID
> StateName
> CountryID
>
> In my editable grid - how to I create a drop down list showing my
countries
> (just need to show country name, not the ID)
>
> My Grid is like this:
>
> State Name CountryID
> (Text) (Drop List)
>
> I want the drop list to display countries from my country table.
>
> Should be easy, but ive never done it.
>
> TIA
>
> Tim Morrison
>
>
|
|
|
Tim Morrison
|
Posted: 04/04/2003, 5:36 AM |
|
Thanks Brian, after looking at it, I could have sworn yesterday was a
Monday!
Tim Morrison
"Brian Gubb" <b.gubb@clear.net.nz> wrote in message
news:b6j54u$801$1@news.codecharge.com...
> Just right click on the text box in the editable grid and change it to a
> listbox. In the properties for the list box select the table you require
and
> the field to return.
>
> Brian
>
> "Tim Morrison" <sales@kjmsoftware.com> wrote in message
>news:b6i959$bvd$1@news.codecharge.com...
> > I have 2 tables Countries and States
> >
> > Countries
> > CountryID
> > CountryName
> >
> > States
> > StateID
> > StateName
> > CountryID
> >
> > In my editable grid - how to I create a drop down list showing my
> countries
> > (just need to show country name, not the ID)
> >
> > My Grid is like this:
> >
> > State Name CountryID
> > (Text) (Drop List)
> >
> > I want the drop list to display countries from my country table.
> >
> > Should be easy, but ive never done it.
> >
> > TIA
> >
> > Tim Morrison
> >
> >
>
>
|
|
|
|