Hi Andrew

Sorry I didn't mention the spec I was using. I didn't think it mattered. I used it because it highlighted the problem most clearly, little did I know that it was the only type of spec that exhibited the problem.

Automated retrieves into separate databases is a non-starter. My client has 20 department managers who use FX. The thought of managing the automation, including managing 20 different databases and shortcuts, is too painful to consider.

I agree with you that the program is doing exactly what it has been asked to do. However, the result is unsatisfactory and confusing.

I will try again.... If the program is not going to allow ALL of the departments within a departmental range to be displayed on a financial statement, because at least one individual department within the range is not ticked, then please don't show departmental ranges on the user departmental restriction list, since ticking those has no effect. I would rather that not be the case, and that departmental range ticking takes precedence over individual department ticking (including new departments), but I can live with it either way.

Departmental ranges should only be available for selection when displaying a financial statement if all of the departments within the range are allowed and the report will display properly. I can't live with having to explain reports not displaying properly.

Steve