Posted 5/18/2021 22:38 (#9012921 - in reply to #9012037) Subject: RE: Has anyone made a grain inventory database in Microsoft Access?
I'm working on the same thing for this fall -- wanting to replace a spreadsheet. Originally, I was going to split loads between two tables, but decided to go with Inbound and Outbound, rather than Gross and Tare.
I also want a table for elevator charges. Another to record elevator ticket data. Probably another to hold Client/Farm/Field data...and so on.
I want to be able to bring up how many bushels each landlord has left, which loads have been paid and what the check amount should be, even track bushels per bin.