Tip for everyone- At 24:13 there is an easy way to get around this small issue to have a vender name sorted by its ID. If you were to add the VenderT to your query and link it to your import query with the IDs being related you can then add in the Vender Name instead of the VenderID and then filter by the criteria of "XYZ computer Wholesale" in the venderName field. This prevents any future changes to venderID messing up other queries down the line.
Reply from Alex Hedley:
It's unlikely that the VendorID changes if it's a Primary Key but filtering on Name might be acceptable but what if the name changes.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.