This is often referred to as a diminishing value list. It's a special kind of conditional value list that automatically drops out values once they have been selected.
Do you know how to create a conditional value list?
FileMaker 12 offers a new approach for diminishing value lists that results in a slightly simpler relationship graph. Do you have FileMaker 12?
Your answers will tell me what to post next.
Yes I have created a conditional value list. I am using File Maker 12. Thanks for the fast response!
Wow.. I'm a bit baffled by the solution but it works! There is no way I would have ever figured that out on my own.
Your solution works perfectly. You are awesome. Thank you so much!