nrw-heute
Posts: 12
|
| Posted: 03/15/2004, 3:42 AM |
|
After a first expirience with:
Listbox in Record Form
http://forums.codecharge.com/posts.php?post_id=44127
I've done the following:
2 textcolumns in listbox
http://forums.codecharge.com/posts.php?post_id=44114
with this statement:
SELECT numgruppe, (typgruppe + ' - ' + gruppe) FROM gruppen ORDER BY gruppe
My problem is now that the value of typgruppe is an integer wich points to a record in another table and I don't want to show the number but the the appropriate field from the second table.
How is this done best in CCS?
_________________
¤free coding¤ |
 |
 |
DonB
|
| Posted: 03/15/2004, 6:47 AM |
|
Just join gruppe to the other table in your query, then display the field
from your other table.
--
DonB
http://www.gotodon.com/ccbth
"nrw-heute" <nrw-heute@forum.codecharge> wrote in message
news:6405596bfc54e2@news.codecharge.com...
> After a first expirience with:
>
> Listbox in Record Form
> http://forums.codecharge.com/posts.php?post_id=44127
>
> I've done the following:
>
> 2 textcolumns in listbox
> http://forums.codecharge.com/posts.php?post_id=44114
>
> with this statement:
> SELECT numgruppe, (typgruppe + ' - ' + gruppe) FROM gruppen ORDER BY
gruppe
>
> My problem is now that the value of typgruppe is an integer wich points to
a record in another table and I don't want to show the number but the the
appropriate field from the second table.
>
> How is this done best in CCS?
> _________________
> ¤free coding¤
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
nrw-heute
Posts: 12
|
| Posted: 03/15/2004, 7:04 AM |
|
Could you explain that a bit in detail by the given SQL Statement?
SELECT numgruppe, (typgruppe + ' - ' + gruppe) FROM gruppen ORDER BY gruppe
The field 'typgruppe' contains a number and this number is a recordfield called 'numtyp' from a table called 'typen' wich from I need the field 'typ' to be displayed instead of 'typgruppe'
_________________
¤free coding¤ |
|
|
|
nrw-heute
Posts: 12
|
| Posted: 03/15/2004, 10:24 AM |
|
O.k. O.k. I should do my SQL homework....
It works, I did it this way:
SELECT (typen.typ + ' - ' + gruppen.gruppe), gruppen.numgruppe FROM gruppen, typen WHERE gruppen.typgruppe = typen.numtyp ORDER BY gruppen.gruppe
_________________
¤free coding¤ |
|
|
|
|
