Edward Lipsett
|
| Posted: 01/16/2003, 11:04 PM |
|
I'm just starting out with CCS, so forgive me for asking what is probably a
stupid question, but after half a day with the computer and the manuals,
it's time to ask...
I have two tables in the same MySQL DB, named Categories and People.
Categories is a list of occupations (author, artist, editor, etc), and has
only two fields: id and category.
People is a list of people with lots of fields (name, address, tel, etc),
including category. I have no trouble getting the Category listbox to
display a list of possible Categories when entering a new People.
The problem occurs in the list of People: the text displayed for the
Category, along with name, address etc, is the id number from the Category
table, not the Category text field from the Category table.
I've tried it from a dozen different directions and can't seem to get there
from here: how can I display the category already set for that person, in a
label, in the Person list?
Any advice cheerfully accepted; flames will be cheerfully ignored.
Edward Lipsett
Fukuoka, Japan
elipsett@intercomltd. Com
|
|
|
 |
Rick Neal
|
| Posted: 01/21/2003, 2:10 PM |
|
I assume that because you are using mySQL that you are using PHP.
If you download the Training Manual from http://support.codecharge.com, you
will find an example Task Manager that shows you how to hide the ID and show
the text of another table's text field.
You could also write a short snippet of SQL to do the trick.
Rick Neal
DJBorg.com Media Services
Anchorage, Alaska
"Edward Lipsett" <translation@intercomltd.com> wrote in message
news:BA4DD988.1D249%translation@intercomltd.com...
>
> I'm just starting out with CCS, so forgive me for asking what is probably
a
> stupid question, but after half a day with the computer and the manuals,
> it's time to ask...
>
> I have two tables in the same MySQL DB, named Categories and People.
> Categories is a list of occupations (author, artist, editor, etc), and has
> only two fields: id and category.
> People is a list of people with lots of fields (name, address, tel, etc),
> including category. I have no trouble getting the Category listbox to
> display a list of possible Categories when entering a new People.
>
> The problem occurs in the list of People: the text displayed for the
> Category, along with name, address etc, is the id number from the Category
> table, not the Category text field from the Category table.
>
> I've tried it from a dozen different directions and can't seem to get
there
> from here: how can I display the category already set for that person, in
a
> label, in the Person list?
>
> Any advice cheerfully accepted; flames will be cheerfully ignored.
>
> Edward Lipsett
> Fukuoka, Japan
> elipsett@intercomltd. Com
>
>
|
|
|
|
|
