ckroon
Posts: 869
|
| Posted: 06/12/2006, 10:44 PM |
|
Hi all.
I have a problem with a database filed and the way MysQl dispalys it in codecharge.
In a listbox are choices for a certain type of medical disability. The client needs a two digit code to be in the spreadsheet, not the text name of it. THe code of hte first disabiltiy, however, is 00. When user does a filter for that disabiltiy, it brings up all the disabilities because the rest of the mbegin with zero (01, 02, 03) etc. Is there a way I can trick the DB?
Thanks
_________________
Walter Kempees...you are dearly missed. |
 |
 |
me!
|
| Posted: 06/12/2006, 11:08 PM |
|
I think I just figured it out. I put them in the order I want in the database, , but don't use the codes as the primary key, make a new column with new, unique primary keys.
|
|
|
|
|
