Newbie - history
I am creating a database that will track the location of roll off dumpsters/containers. Our dumpsters have specific numbers (85-1, 85-2, 85-3, etc.) so I created a record for each dumpster (there are approx. 80 of them). If data is entered that dumpster "A" was in Boston last week and the dumpster is then moved to Concord this week, won't I lose the previous Boston data when the new Concord data is entered? I guess what I'm asking, is it possible to keep a history of each dumpster's location and the data associated with it? Do I need to set up the data base differently for a history to work?
Also, I have a "Number of Days at Location" field. This field would be based upon the date the dumpster was dropped off at a specific location and the current date. However, I cannot get this to work unless I actually go into the specific record and edit data. Is there a way to get this to function when in browse mode and just clicking through the records?
Thank you in advance for your help.