Ideally you will join your data as it comes into Tableau: http://kb.tableausoftware.com/articles/knowledgebase/join-vs-relationship-60
You may face some issues because of the multiple rows per vehicle in the second dataset.
Thanks for the quick response, I have tried this but am not getting a correct result set. I always get the following:
Is there anyway I can do this by linking on the vehicle id?
You will need to set the Join as Vehicle ID from table a = Vehicle ID from table b
I already have this in place as the tables are joined using Vehicle Id, I wondered if there was anyway of combining options within Tableau bu utilizing the vehicle id.
Don't follow what you mean.
The best way would be if you could post your tbwx, with sensitive data removed if necessary, and the expected result from that data set.