Hello, I am using MS access and need to create a table thats pulls part numbers from two other tables and outputs them into a single field. please show the steps required to do this. thank you.