|
M
|
MaxxaM 4/15/2009 |
|
If I had a dollar for everytime I've had to do this.. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=40182&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> I've got a table with a couple of keys that link to a lookup table. For example, 1=North America, 2=Asia Pacific, etc for the field "Region". If I try to search by region, I can only search by 1 or 2. If I type in "North America" or "Asia Pacific" I get no results. Is there any way other than storing the actual Region name in the table to enable searching by this field? The field is set up in the Lookup wizard: Table: RegionTbl Link Field: RegionTblID Display Field: RegionName Order by: RegionTblID |
|
|
S
|
Stettin author 4/15/2009 |
If I had a dollar for everytime I've had to do this.. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=40184&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> Ok..First off you need to make sure the searchable region is in your sql code in the "edit SQL query" of PHP Runner. Now go to your "Choose Fields' section(all the check marks), for the list page you will want to check the id...for the search page you'll want to uncheck the id and check the region that you added to the sql code. This will allow you to search on region, but your list, edit, and add pages can use the id (along with the lookup table). Hope that answers your question...
|
|