Hi

Unfortunately there doesn't seem to be any documentation around this either way.
I have a document type e.g. Recipe, which has a RecipeID.

I'm using the UserContributions module in order for users within the live site to be able to add recipes. However, I need to be able to display a list of RecipeIngredients in a dropdown list for each Recipe.

The query I need for the dropdown list in the Document Type configuration/user contribution form is:

SELECT IngredientID, IngredientName
FROM Ingredients
WHERE RecipeID=@RecipeID

Supplying the recipe ID from the document type being edited.

Is this possible? Or do I need to hack around with the UserContributions view to manually populate the dropdown list at the View level?


Thanks in advance