Hi @Sevanna_Shields ,

I would suggest the sub departments to be a Single Select field with the actions done by each department being a checkbox. You can then create views to see where the record is at.

See unfortunately, the issue isn’t as simple as being able to put it all on one table. We currently have 250+ columns that way. And we can’t all work in the same base. Each sub-department can’t have access to all of the information, only the records within their sub-department. And we need dates for the actions, statuses of the actions, and such so we can’t just use checkboxes.

Ideally we’d have

A base per sub-department, with one main base where records and info could be distributed from. But we also need the sub-department to make any changes it needs as well.

Essentially the Department Base needs to record all records and changes made to those records. Even if changes are made in a sub-department base.

I Department Base

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-1

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-2

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-3

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-4

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-5

I I_ Demographics

I I_ Actions

I I_ Licensing

I_ SD-6

I I_ Demographics

I I_ Actions

I I_ Licensing