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

• 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)

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.



So, I guess I just need some help with this.



Thanks

Ep