MS Access 2007
I have a two tables that I am working off of. I choose a person from one table and a place from another, both from a lookup column. I need to know how to gray out (or something along those lines) the place that I choose so that it can't be chosen again. Is this possible, and does anyone know how I would go about that. I don't want it deleted from the orginal table, just hidden so that it can't be chosen again.
I have a two tables that I am working off of. I choose a person from one table and a place from another, both from a lookup column. I need to know how to gray out (or something along those lines) the place that I choose so that it can't be chosen again. Is this possible, and does anyone know how I would go about that. I don't want it deleted from the orginal table, just hidden so that it can't be chosen again.
