Hi,
Hopefully an easy questions.
RecipeTable
PatientTable
PatientRecipeTable
PatientID |
RecipeID |
1 |
1 |
1 |
2 |
Now I want to make sure that all Patients are mapped to a recipe.
Code:
SELECT ID, NameFROM PatientTable
WHERE NOT EXISTS (SELECT PatientRecipeTable.PatientID
FROM PatientRecipeTable
WHERE PatientTable.ID =PatientRecipeTable.PatientID)
Gives me the data I want from my PatientTable. How can I update my query so I get a third field, a combobox/dropdown with all available recipe from my recipe table?
I also want that value entered in this combobox/dropdown also updates my PatientRecipeTable?
Really appreciate some help on this.