I have created a report that returns the following data from a transaction table, which is great.
Yard ID Stock Code Qty Date
3 001202 60 15/08/2012
The problem is I dont want to show the Yard ID, but the yardName, which is stored in another table.
Is there a way to link the two tables via the yard ID
many thanks in advance
Yard ID Stock Code Qty Date
3 001202 60 15/08/2012
The problem is I dont want to show the Yard ID, but the yardName, which is stored in another table.
Is there a way to link the two tables via the yard ID
many thanks in advance