sanit kiriwong
|
| Posted: 08/04/2001, 1:08 PM |
|
Hi,
How I use SQL statment for lookup data in main table like this :
I search field building_name from table building (Building_name can
duplicate) and lookup building_name by lookup SQL "Select distinct
building_name from building order by building_name" .The list box not show
any thing.What am I doing wrong?
Regards,
Sanit.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/06/2001, 4:57 AM |
|
sql statement for LOOKUP sql must have the following form :
select id,value from table [other clauses]
field list must consist of 2 params , one is to be shown ,
another is to be submitted
--
Alex
CC
sanit kiriwong <wongsa@ksc15.th.com> wrote in message
news:9khko7$hu5$1@news.codecharge.com...
> Hi,
>
> How I use SQL statment for lookup data in main table like this :
> I search field building_name from table building (Building_name can
> duplicate) and lookup building_name by lookup SQL "Select distinct
> building_name from building order by building_name" .The list box not show
> any thing.What am I doing wrong?
>
> Regards,
>
> Sanit.
>
>
|
|
|
|
sanit kiriwong
|
| Posted: 08/07/2001, 5:30 AM |
|
Hi,
I use view for this case.it's ok.
Thanks,
Sanit.
Alexey Alexapolsky <alexa@codecharge.com> wrote in message
news:9km0mg$khp$1@news.codecharge.com...
> sql statement for LOOKUP sql must have the following form :
>
> select id,value from table [other clauses]
>
> field list must consist of 2 params , one is to be shown ,
> another is to be submitted
>
> --
> Alex
> CC
>
> sanit kiriwong <wongsa@ksc15.th.com> wrote in message
>news:9khko7$hu5$1@news.codecharge.com...
> > Hi,
> >
> > How I use SQL statment for lookup data in main table like this :
> > I search field building_name from table building (Building_name can
> > duplicate) and lookup building_name by lookup SQL "Select distinct
> > building_name from building order by building_name" .The list box not
show
> > any thing.What am I doing wrong?
> >
> > Regards,
> >
> > Sanit.
> >
> >
>
>
|
|
|
|
|
