I have a custom prompt that doesn't affect anything, its mainly used for reports "Exterior Finish Type".  The drafter can select something or custom write a new finish.

I need to find a way to tell IT how to get that information from the SQL file, Projects->LinkID, ProjectWizard->LinkProjectID->???

However I cant find any cell to reference it.  Is there a way to get that Wizard Prompt into the server SQL file?  The closest I can think of is making a Formula Driven Project Level Material named after it.

Anyone have any other ideas?

Thanks,

-James

Edit:

If there is another way not using this prompt in particular, but something the drafter might have to write, or another way to reference it that isnt a wizard prompt, that would be acceptable.