2. PHPRunner General questions
  3. Lookup table problem
This topic is locked

Lookup table problem

 		12/30/2007 4:04:07 PM
PHPRunner General questions
D
 dmcconnell author

Hi,
I'm hoping someone can help me with this lookup table problem. I have a "lookup wizard" field as follows:
Table: title

Link Field: title_id

Display Field: title_id + ' ' + name

Order By: title_id

Using Edit box with AJAX popup, but have also tried it as a non-AJAX lookup
The actual data is the title table for the title_id field is:
220-66J30

192-99334

322-00321
The lookup actually works, but in either the AJAX popup, or the regular dropdown lookup, then only part of title_id that is displaying is the part before the dash (-), (ie. 220, 192, 322, etc) How can I make the whole field show?
Also, should I not be able to expand the fields in Visual Editor? I can go to a page, select a field, and I can get the double-headed arrow but I cannot drag it to make the field larger.
Thanks,

David
J
 		Jane 1/8/2008

David,
what database do you use: MySQL, MSSQL, Access?
Regarding the second question.

To increase size of text field on the add/edit page change Size of these fields on the "Edit as" settings dialog. Unfortunately you can't change size of dropdowns on the add/edit pages.
D
 		dmcconnell author 1/8/2008

Jane,
Thanks for the reply. I'm using MySQL. I got the dropdown working, I wasn't using the correct syntax for MySQL, so once I fixed that, it works fine now. I would however like to make a suggestion concerning the Ajax lookups, since I'm using 2 fields for the lookup, title_id and name, the Ajax popup is using 2 lines for each selection.
Example:
Here is what I would like to see in the popup:
226-6647J - Office Professional 2007
Here is what I am seeing: (It's wrapping the 2007 to the next line)
226-6647J - Office Professional

2007
Thanks,

David