I have an Agencies - Departments - Functions arrangement where each has an ID. I'd like to auto-generate ID numbers for each and be able to regenerate the same numbers for each new entity. For example: Agency ID 1, Agency ID 2, ...Agency ID n. Then for each agency's departments, Dept ID 1, Dept ID 2, ...Dept ID n. And similarly for Functions so that given different agencies I'd have:
Agency ID 1 - Dept ID 1 - Function ID 1;
Agency ID 1 - Dept ID 1 - Function ID 2;
Agency ID 1 - Dept ID 2 - Function ID 1;
Agency ID 2 - Dept ID 1 - Function ID 1, and so on.

I'd appreciate some ideas on how to go about doing so. I'm currently using Visual FoxExpress. It provide a VFENewKey function that autogenerates values but does not regenerate them as above.