Pulling data from another table (UPS tracking numbers)
We have two tables:
Open Orders (has a Sales Order # entered at order start)
Tracking Data (imported from UPS with the Sales Order # as a column once the order has shipped)
Trying to create a view that will list all the line items in Open Orders and pull the tracking number from the Tracking Data table when the Sales Order # matches.
Any advice is GREATLY appreciated.