Value List with Unique Values

[hillnick]

I couldn't find what I was looking for on the forum.  

 

I was wondering if it's possible to create a value list showing only unique values.

 

Example: 

 

Camp sites value list showing:

 

Site #1

Site #2

Site #3

Site #4

 

Record 1 of a reservation table selects Site # 2.

Record 2 of the reservation table would now see the camp sites value list as following:

 

Site #1

Site #3

Site #4

 

Record 2 selects Site #3.

 

Record 3 would see the camp site value list as:

 

Site #1

Site #4

 

 

Hopefully I explained what i'm trying to accomplish clear enough.

 

Thanks for your help in advance.

 

 

 

 

 

[bcooney]

I think what you're trying to accomplish is a booking system. Perhaps this demo will help from Ray Cologon.

[Brooks]

What I would use is a dynamic value list based on executesql. The how to is way to involved for a forum post but everything you need is here http://www.filemakerhacks.com/?p=5412