Only to be a bit more clear, in SQL I will use NOT IN
This is called a diminishing value list. A conditional value list can be defined that excludes previously selected values.
Please describe your tables and the relationship linking them (if any).
This is also my case and I am glad I found this post. Can you please take a look at my case?
My tables are:
- An Orders table for the products I buy.
- Each Order has many Serial Numbers which are stored in a Serial Numbers table.
- When I sell a product, I prepare an Invoice. This information is stored in an Invoice Data table. In this table I have a Serial Number field where I select the product's Serial Number from a conditional Value List.
What I need to do is to exclude from this value list the serial numbers already used. I have tried many senarios, but I cannot achieve the required result.
Can you please help?
Since this thread was created, I've launched a series of instructional database files called Adventures In FileMaking. They are free to download and explore and Adventures in FileMaking #1's topic is conditional value lists. You'll find a working example of a dwindling or diminishing value list on the Dwindling Value list exploration layout in this file along with a very detailed description of how it works and how to set it up.
OK. I will study your Adventures. Thanks a lot.