Forum Moderators: open

Message Too Old, No Replies

Join Problem?

         

trevordixon

6:41 pm on Dec 27, 2006 (gmt 0)

10+ Year Member



Is there a way to get a list from one table, then mark a field true if that value exists in another table? Example:

Items
Item 1
Item 2
Item 3
Item 4
Item 5

Selected Items
Item 2
Item 4
Item 5

Query
Item 1, False
Item 2, True
Item 3, False
Item 4, True
Item 5, True