View Single Post
  #12  
Old August 26th, 2009, 06:12 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default AARGGH!! How to store data - HEEELLLPP!

Hello Phil,

Answering your quesitons....

Not sure what you meant by "instance". If, by that you mean an instance of
one ad being in one magazine for one month, for better or for worse my
structure does not have that. And so such a record would not exist or be
created. All answer are derived from looking at the purchased "block" of
ads in a particular magazine.

The one table would hold it for all of the magazines. The "ProductID"
field would identify which magazine the OrderItem is for.

Hope that helps a little.