This topic is locked

Limit Lookup Field

3/31/2006 12:31:20 PM
PHPRunner General questions
T
Tommy B author

I have a table for collecting credit card transactions. A part of the add page includes a "lookup field" that pulls a list of company names from another table. Within the second table is a field that says wether or not that company accepts credit card payments or not.
Is there a way I can limit the lookup field to only include companies that do accept credit cards?

Sergey Kornilov admin 4/3/2006

Tommy,
you can do it using Where clause on the Edit format dialog on the Formatting Tab.

See my example:

"accept_field = 1"



Don't forget about quotes.