Posted 5/18/2021 15:20 (#9012037 - in reply to #9010959) Subject: RE: Has anyone made a grain inventory database in Microsoft Access?
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.