Mike
|
| Posted: 11/14/2002, 2:34 AM |
|
I want in my Form Title a Join.
Example, I have a Form type grid and uses the table news.
Table: News
news_id | newsname | date | product_id
I want to show in my Form Title the productname from the table Product. If I put in my Form Title: {product_id} I only see a number. How can i make a join for this to show the product name?
Table: Product
Product_id | productname | description
|
|
|
 |
Mike
|
| Posted: 11/14/2002, 2:45 AM |
|
I use the language PHP 4.0 & Templates with MySQL
|
|
|
|
Mike
|
| Posted: 11/14/2002, 4:34 AM |
|
Hi Mike!
although I started working with CCS shortly ago I think I can help u out:
download the CCS tutorial form: http://download2.codecharge.com/pdf/CCSTutorial1_0.zip
and read it from the beginning  it' great fun an easy to understand ... on page 22 - 27 or so you will get your answer
Nitedula
|
|
|
|
Mike
|
| Posted: 11/15/2002, 12:29 AM |
|
I use CodeCharge 2.0 not the Studio... And I could not find this in the manual of 2.0
|
|
|
|
RonB
|
| Posted: 11/15/2002, 2:24 AM |
|
select news.news_id, news.newsname, Product.productname from news, produkt
where news_produkt_id=Product.Product_id
|
|
|
|
