Edmond Sane-Aka
asked on
Agencies document tracker
I'm creating an agencies document tracker database. I've already started the database which I've attached. But i want to format the database so that the DERA table will be the main table follow by the counties and agencies so that he can look like the second attachment. Any assistance will be appreciated.
Agencies.accdb
Document.pdf
Agencies.accdb
Document.pdf
ASKER
slightwv,
thanks for the advice I'll try that
thanks for the advice I'll try that
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
If DERA is the main table and Counties is a child table, it will likely be a many-to-many relationship.
If so, you will need an intermediate table like dera_county that holds dera.id and county.id.
Same for the relationship between counties and agencies. If ALL agencies are in the same county then you might get by with just adding a county_id column to the agencies table.
That said: The agency and county tables are pretty much the same format. I might think about merging them into a single documents table with a owner_type column with a 'C' or 'A' column to designate County or Agency.
If you have additional columns for county that don't belong to agencies then you can create separate county and agency tables but I would look to keep the document table independent with the appropriate foreign key column in it.