Multiple Value Lists
Is it possible to use more than one Value List in the one field?
For example, I am creating a purchasing order system in FMP10. I will have a field called "Supplier". If the supplier field shows ABC company, I would like to "Value List A" to show up. If the Supplier field shows 123Company, I would like "Value List B" to show up.
Can this be done?