Hi all,
I was curious if anyone might have a few design suggestions. I've hit a wall in how I'd like my database to look and how it should be represented in forms and am turning to everyone for ideas!
The set-up:
My database keeps track of an inventory within a state. I have a tblSurplus to track all of the inventory we have handled and a query qryCurrentInventory to display all of the inventory we still have on hand, and a form based on this query to display that information. Additionally there is a table, tblDisposals, to track what current inventory has been logged as disposed of either as a sale or as a transfer. This distinction is important because if its transferred I need to track what customer it was transferred from and to whom it went. Simple enough!
The Goal:
I would like to be able to select a record within the current inventory query and be able to list it in the tblDisposals as either sold or transferred. If it's transferred I need it to display where it came from and where it went. (I already where it came from in the tblSurplus). As I'm a complete novice avoidance of code (if possible) would be greatly appreciated!
I seem to have hit a creative block and am getting burned out as I have had to teach myself form scratch this last month so any help would be greatly appreciated!
Thanks all!