Re: PO generator
I gave you pretty specific instructions on how to begin to normalize your schema so you can move forward with Access. Keep in mind that relational databases are very different from spreadsheets when you get behind the curtain. In a spreadsheet, the data layer and the presentation layer are merged and that causes considerable repitition and impedes the ability to produce different kinds of reports. It also makes it a monumental chore to add new horizontal values.
If most of your POs include three items, you are wasting 27 instances and what happens if one PO must have 32 items?
Bridge Players Still Know All the Tricks
Last edited by Pat Hartman; 07-25-2019 at 06:20 AM.