Morning all, I'm quite new to Crystal, but have many years experience using SQL on a Unix platform, so please be gentle if I'm asking silly questions! I have an existing Crystal report (written using V8, and doesn't work in V10) which I need to modify. When the report is run, it prompts for 2 search criteria (specifically, depot names and a price structure). Depot names are held in a separate table (spookily called STO_DEPOT_NAMES). The dropdown from the search criteria input doesn't match what's in the STO_DEPOT_NAMES table for some reason... I'd assume is was a simple SELECT statement to retrieve the depot names... but I can't see how I can check/edit the prompt. If you could please help me to find how the prompt drop-down list is generated, it would be a big help.