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?