Dynamic Where Clauses

Questions and Help
1

I think the answer is "no," but I'll ask anyway. Is there a way to have a form pop up requesting the numeric order id in the following code, or have the query reference an active row without having to edit the snippet each time you need to change the "XXXXXXXXX"?: {dbselect: SELECT contention_pullout FROM Worksheet WHERE includes(order ID, "XXXXXXXXX"); space=3HBVazviacNmTCdPgdgPDK; multiple=yes; menu=yes; name=selected_items}

Thanks!!!

2

Hi Terry,
Is this what you had in mind?

id = {formtext: name=id}
{dbselect: SELECT Name FROM Table1 WHERE orderid=@id; space=id; menu=yes}