hi
i have a query subject of diagnosis which contains 1000's of codes and descriptions. I want to use a subset of these codes which meet certain criteria such as falls, scalls, head injuies and car seat accidents in a select prompt to be used as a filteria in a report.
Instead of showing all diag codes i want to use maybe 100 in prompt list
thanks
bunker
That is purely a matter of having the proper restrictions on the query that feeds the prompt. There is not a clear distinction here in building a query that is used by a prompt and one that feeds the report with data. (in both cases use filters to restrict values / data fetched)