This topic is locked

Dropdown in search fields

3/23/2009 8:34:23 AM
PHPRunner General questions
T
tcgass author

Hello

I have a database where a couple of datafields taht are linked to lookup tables with dropdown menues, e.g. "SupplierCompany". The datafield

itself is linked to the "SupplierCompany-ID", the displayed field is the "SupplierCompanyName" field.

On the extended search page these dropdown menues are visible as well, so I can make a search for supplier company "XYZ Ltd."

by simply choosing that name from the dropdown list.
When searching with the simple search functions (presented on the list page) however, I have to search for the "SupplierCompany-ID"

number - how could I manage to have the same dropdown box with the linked "SupplierCompanyName" data appear here?
Thomas

J
Jane 3/23/2009
T
tcgass author 3/23/2009

Hi Jane
thanks for your reply! I've seen this article before, but can't figure out how to solve my problem... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=39338&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
I suppose the
FROM `products` INNER JOIN `categories` ON `categories`.`categoryID`=`products`.`categoryID`
part is essential for having the dropdown box in simple search as well?
Thomas

J
Jane 3/24/2009

Thomas,
you need to join two tables on the Edit SQL query tab and then check off joined field on the list and search pages on the Choose fieldtab.