Relationship

[Don Sloane]

I have a table names Contacts.  I am trying to create a relationship for a drop down list that will not include the current contact in the list.  For example: I have Bob, Ted, Mary and Alice as data.  When I am on Bob's record I want to have the drop down only include Ted, Mary and Alice.

 

Thanks...

[comment]

You need a self-join relationship (using another occurrence of the Contacts table), defined as:

 

Contacts::ContactID ≠ Contacts 2::ContactID

 

Then define your value list to use values from Contacts2::ContactID, include only related values, starting from Contacts.

 

 

Hopefully, you are using unique id's to select your contacts, instead of names.

 

 

---

P.S. Is that the most descriptive title you could have thought of?

[Don Sloane]

Thanks much.  I had everything as you described EXCEPT the include only related values... it was late, i was tired, arghh!  Hence the underwhelming title 

 

Again, thanks!