@creece, I want to get all assembly build items and their usage codes. Usage code is a custom field in a custom record called custrecord_recipe. Both assemblybuild and custrecord_recipe have an item field so I'd want to join them based on that if I were doing MySQL or the like.