We have a list of products which appear as options in other tables such as enquiries and projects. There is a field in our products section which has an active/obsolete option, which differentiates whether the product is still being sold or whether it has been decommissioned.
Currently when choosing a related product in the other areas of our database, the drop down list shows all products, however we want it to only show the active ones on the list as these are the only relevant records. Looking around it seems I need a Conditional Value List? I am still relatively new to FMP and have inherited the database to make some drastic changes to improve the efficiency and ease of use.
Could someone give me some advice as to what I need. It seems like a simple enough task in terms of what I need, I just can't get my head around how to do it. Cheers!