I cant determine how to do the table structure for handling cycling counting. Do I need an audit table? Or is one table with before/after quantities enough? Do I need to lock tables while the DB is in "cycle count mode" to prevent records from changing? I can see so many different possible methods that I am going cross eyed and have confused myself.