Default Department Name from table

[DubboPete]

Hi all,

I have a series of reports which are generic for departments. I have a
table of Department names which consists merely of DeptID and DeptName.

I would like to get the Deptname to appear on each report, but
obviously to default to whichever department is using the report.

What's the easiest way to do this?

TIA
DubboPete

 

[Chris]

You will first need to know who is running the report. That will need a table
of userids and their department

Then when you produce the report, you can default the department to that of
the user