|
OK Panhandle | Thinking about what you're trying to do, I think splitting inbound and outbound into different tables is complicating things. If you think about it, they are both just grain movements - either a debit or a credit. If you follow strict double-entry accounting practices, you could keep all the information in one table, plus then you have a built-in audit log if you need to research something. Would sure make running queries easier because you could just tell the database to sum all the activity for bin X to get a balance, or run a group by on owners to get balances for each owner, or run a group by on bins to get inventory balance by bin, etc. No table joins involved.
If you set it up this way, though, you're back to having a database do the job of a spreadsheet. | |
|