Hi, I am currently having a problem getting a true/false
value from a table based on the values in the two other fields.
My three fields are in the table are client names, boxno, missing (which is true/false). I have a combo box with clients names which after update affects a listbox contents (boxno). Sometimes this listbox contains more than one value (a client may have >1 file). Depending on which value of this listbox the user clicks on, I want the database to tell me whether or not this file is missing (ie true / false for that particular record).