Need hand creating a value list
Client Table contains a portal of Tours (ClientTour table) a client has taken, or is about to take. I have a button (thanks Phil), that will set the "working tour" (so I have a TO called ClientTour|Working) fkID to the ClientTour pkID. On the same layout, I've got a few fields that I want to have a drop down for, to select things like "roommate" and such. All I want is a drop down that shows other Clients that are on the same tour. I probably need new TOs, but I can't seem to get a handle on it. Any suggestions are appreciated.