Bob:

One of my clients using FX also has a database where new departments are added all of the time. We use the auto retrieve:

[Retrieve11]
Database="G:\DATA\HYSCAL\CONST\GLGLOB.CAL"
UserID="FX"
Password="FX"
Department="CALC"
AppendData=1
RetrieveAllYears=1
ReplaceDepartment=1


For your purposes I wonder if this would work (changing our setup from creating a fixed department in FX to one that should create a variable department):

[Retrieve11]
Database="G:\DATA\HYSCAL\CONST\GLGLOB.CAL"
UserID="FX"
Password="FX"
Department=CALC*
AppendData=1
RetrieveAllYears=1
ReplaceDepartment=1

We are not using 'SelectedDepartment' at all, which (I assume) means that we retrieve them all.