Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-22-2019, 11:52 PM   #16
TheJoeness
Newly Registered User
 
Join Date: Jul 2019
Posts: 9
Thanks: 6
Thanked 0 Times in 0 Posts
TheJoeness is on a distinguished road
Re: PO generator

Added I might also delete it and just start over, might be the best approach to doing this thing properly.

TheJoeness is offline   Reply With Quote
Old 07-24-2019, 02:15 PM   #17
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,946
Thanks: 13
Thanked 1,531 Times in 1,457 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
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.
Pat Hartman is offline   Reply With Quote
Old 07-24-2019, 11:01 PM   #18
TheJoeness
Newly Registered User
 
Join Date: Jul 2019
Posts: 9
Thanks: 6
Thanked 0 Times in 0 Posts
TheJoeness is on a distinguished road
Re: PO generator

Quote:
Originally Posted by Pat Hartman View Post
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 each other 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?

Thank you very much for that input, I have been struggling with that question. I haven't had the time to look into your previous suggestion, but your energy will not be wasted, nobody's advise will fall on deaf ears.


TheJoeness is offline   Reply With Quote
Reply

Tags
database beginner , database design

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Survey Generator MStCyr Sample Databases 0 09-05-2006 08:40 AM
Quote Generator Help Sandpiper General 3 03-05-2006 06:05 PM
OrderID Generator latex88 Modules & VBA 3 11-11-2005 09:59 AM
Report generator macca_24 Reports 4 04-01-2003 04:56 AM
Report Generator Len Boorman Reports 0 04-01-2003 01:12 AM




All times are GMT -8. The time now is 03:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World