This topic is locked

Lookup Tables

3/25/2008 9:15:33 AM
PHPRunner General questions
M
mrphp author

I have a lookup table that pulls company names from a business address book for a project record. There are instances when there is no applicable company for the particular project. I'd like to have the option to select "Unknown" as the company name. However, I don't want to allow "select on the fly" because of a need for consistency. I could add the company name "Unknown" to the address book but would rather not. Is it possible to create a custom expression for the display field that would pull from the address book and also allow the selection of "Unknown"?
Thanks.

J
Jane 3/25/2008

Hi,
you can add "Unknown" value to the lookup table and select it in the dropdown box on the add/edit pages.

To hide this record on the list page of "business address book" table add where clause on the Edit SQL query tab.