Arthur Dent
|
| Posted: 03/05/2003, 8:11 AM |
|
I posted this problem before and never got a reply,
I need help
I have a grid + search + Add/Edit
Search and Add/Edit have two text boxs and two listboxs
Problem
when I addnew or edit records,the updated grid records
from the list box entrys show the primery key value not
the text value.
working with CCS asp
List box propertys
list source type =table
list data source =category_id (from my main table)
bound column =category_id (primery key from category table)
Text column =category (text field from category table)
Table Parameter
field
category_id equals category_id
(primery key)
When i link my tables do I
Link Primery Key with primery key
or
Primery key with text field?
where am I going wrong
I Need help not Redirection to manual or projects not even basic coders school.
Arthur Dent
|
|
|
 |
Ford Prefect
|
| Posted: 03/06/2003, 6:39 PM |
|
Very hard to guess what you are doing , can you view the source of your output page and check the Option values.
Normally values will appear when there is NO Exact mact in the option list.
e.g. Your list says 1=AA,2=BB,3=CC and you set a value of 5, then 5 will appear.
Hope that helps.
Ford
|
|
|
|
Rob
|
| Posted: 03/06/2003, 6:54 PM |
|
Hi there,
I think I see what you trying.
I ran into similar, I like simplicity and I am very rookie -
so what I did for some of my categories is just do away with the ID # and use the description as the primary key (one word only). So far so good! Have not had any trouble with this method. If there is a hidden problem/issue with tis method, somebody please let us know :)
Take care
|
|
|
|
|
