Create a list of all of the values in a column

Is it possible to create a list that has all of the unique values in a column in a different table?  For example, suppose Table A has an order number field and I want to see if the order number entered in Table B is in the orders in Table A.  What is the best way to do this and make sure the list updates with each new record in Table A?

------------------------------
Paul Peterson
------------------------------