That's useful. Is there a way to add a prompt field for an input that doesn't exist in the table? It looks like in Prompt Dialog options, I can only select from the table that I'm in on dbFront, but if I a have a SP that looks at other tables and requires and input for those, I cant just add a blank input parameter to pass through that links to the input on the SP.
Example: I have an SP that has 6 input parameters. 4 of them I can pick, 3 of them are parameters the user has to type in e.g. StartDate and EndDate.