I am in a small city and we now have to have some mechanism to account for our signs - all signs in the city control.
So.... I have tried to figure out a design schema, but am getting frustrated that I can't seem to get it even close.
What we need to do is
I don't want to delete any records - for historical data collection - and would like to make some kind of an active/inactive file/table(?) to keep track of these.
- account for each sign
- what type
- when purchased
- who purchased from
- cost of sign
- type of facing (new or refurb)
- account for where and when it was put in the field
- date installed
- post installed on
- location of installation
- direction sign in facing
- GPS coordinates
- date removed (make it inactive?? or ??)
- account for signs not yet installed (in shop)
So, I guess I just need some help with this.
Thanks
Ep