Here is the basic layout of the data:
There are 4 tables,
1. Dept (contains a list of departments) Key: DID
2. Contacts (A list of people who work) Key: CID
3. Dept_Cont (Links CID & DID) Key: DCID
4. Assn (Assigns a DCID to existing data)
What I am wondering is how to make DCID in the Assn...