SELECT mfr.mfr_id, mfr.mfr_name FROM tblManufacturers mfr ORDER BY mfr_name

-- Select Manufacturer -- #mfr_name#

SELECT * FROM tbl_REC_Items WHERE mfr_id = ORDER BY recipeId SELECT * FROM tbl_REC_Ingredients WHERE recipeId IN ( ) ORDER BY recipeId SELECT * FROM tbl_REC_Instructions WHERE recipeId IN ( ) ORDER BY recipeId, instructionStep SELECT rItem.recipeId, img.imgPath + '' + img.imgName + '' + img.imgExt FROM tbl_REC_Items rItem JOIN qryImageLookup img ON rItem.recipeImage = img.imageId WHERE mfr_id = ORDER BY recipeId theDir = GetDirectoryFromPath( GetCurrentTemplatePath() ); theFile = theDir & "Recipes.xls"; theSheet = SpreadsheetNew( "Recipe Items" ); SpreadsheetAddRows( theSheet, qmd_recItems ); theSheetTwo = SpreadsheetNew( "Recipe Ingredients" ); SpreadsheetAddRows( theSheetTwo, qmd_recIng ); theSheetThree = SpreadsheetNew( "Recipe Instructions" ); SpreadsheetAddRows( theSheetThree, qmd_recIns ); theSheetFour = SpreadsheetNew( "Recipe Images" ); SpreadsheetAddColumn( theSheetFour, "RecipeId", 1, 1, true ); SpreadsheetAddColumn( theSheetFour, "Image URL", 1, 2, true ); SpreadsheetAddRows( theSheetFour, qmd_recImg ); SELECT ri.recipeId, ri.recipeName FROM tbl_REC_Items ri WHERE ri.mfr_id = ORDER BY recipeName

-- Select Recipe -- #recipeName#

No Recipes Found! SELECT * FROM tbl_REC_Items WHERE recipeId = #qmd_testing.RecipeId# - #qmd_testing.RecipeName# --->