I am working on a restaurant inspection form for our health department. In discussions of what the form would look like it was mentioned that it would be handy to enter the permit number and have the header info pre-populated (establishment name, address etc.). I was able to get this to work in a test environment using the table of restaurants but after reading this blog by James Tedrick I see that it isn't wise to use a table that is updated frequently. Our table of restaurants will be updated somewhat frequently.
My question is this - Is this a deal breaker? Can I still use my table but time the updates so that the inspectors will have the most up to date table and not lose any of the inspections they have done?
Summit County, Utah