I am taking two inventory tables and combing them into 1.
What I am trying to do is take the Purchase Order # field from the tblPO and the Sales Order # field from the tblSo table and merge them into 1 column.
This way I can start to look at the inventory data as if it were like an d accounting worksheet with PO being positive numbers and SO being negative numbers.
I assume this is a newbie question, but I just can;t figure it out.
Thanks for any and all help