Re: How would you...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Each site may produce, inventory and sell certain products. (not all sites
produce or sell all products)

I don't need to track to whom products were sold, we have another program
that tracks that information.

And, I'm only creating this database (for now anyway) for this region.



"Jeff Boyce" wrote:

So it sounds like you have Products, and Sites, and Inventory (?product @
site?).

It also sounds like your Sites belong in (one and only one?) region(s).

Are your Sites both "Production" sites and "Inventory" sites, or only
one/other?

Are your Sites "Sales" sites, in addition to the previous answer, or are
they solely "Sales" sites?

Do you care about to whom (i.e., Customer) you sell? Do you need to keep
track of to where (i.e., Delivery Address) and when you deliver?

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"stonelady" <stonelady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:71DAC23E-6911-4C48-BAD0-65CB664A0EB0@xxxxxxxxxxxxxxxx
Each of our sites produces and sells stone of varying sizes. I need to
record and track inventory for each site/product and at a higher level for
the region.

I'm trying to determine the best way to link each product to a site, so I
can pull out site-specific inventory, production and sales figures.

"Jeff Boyce" wrote:

I still don't understand your business. "How" depends on "what"...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"stonelady" <stonelady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EFC6B8E4-F0C6-4861-8E3C-7961C9F6A4E8@xxxxxxxxxxxxxxxx
I need to be able to report how much product is on-hand, produced and
sold
for each site.

All also need to report how much of a certain product is on-hand, for
all
locations.

I would love any suggestions on making this cleaner!

"Jeff Boyce" wrote:

NOTE: I'm not saying it is necessarily incorrect, just that I don't
know
enough about YOUR situation to tell if it is...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"stonelady" <stonelady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0D18ECE4-CDBA-4244-B3B4-555CF19378C4@xxxxxxxxxxxxxxxx
I've posted a few messages and have received really excellent
responses
(THANKS!).

I'm trying to structure my database correctly the first time.
Basically, I
want to track production and sales at various sites.

Iwant to see all inventory for a product across all sites, or for
each
site,
etc.

Many products can be produced & sold at different locations.

I was thinking of setting up the following tables:

SiteID
SiteID
Location

ProductMaster
ProductID
ProductDesc
SiteID

Production
SiteID
ProductID
ProdDate
ProdQty

Sales
SiteID
SoldDate
ProductID
SoldQty


Does this look right? My database programming skills haven't been
used
in
a
while, and there are no programmers here to bounce ideas off.

All thoughts and suggestions are greatly appreciated!









.

Relevant Pages

  • Re: Sold Shaman set... :[
    ... > vanished from your inventory, ... I'm not blaming them because of my mistake. ... I can understand if I sold an apple but it was an armour set I paid 60g. ... realized I lost it I was in an istance. ...
    (alt.games.warcraft)
  • Re: Inventory Database
    ... Create an option group on the Sales form with 4 option buttons or a combobox ... > I am working on creating a timeshare sales and inventory database. ... > be sold either by odd years, ...
    (microsoft.public.access.gettingstarted)
  • Re: Mass Effect 2 Out - IGN Review 96%
    ... The inventory container interface is also ... hold onto this in my already overflowing gem bags! ... or 3 gem bags which were also overflowing (no need to sell anything by ToB ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: Update top n records
    ... Thanks for letting me clarify this; it helps me sort it out in my own head. ... Table Inventory has every widget in inventory with only ... I want to update table Inventory n number widgets with new location (e.g., ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: How would you...
    ... So it sounds like you have Products, and Sites, and Inventory (?product @ ... Are your Sites "Sales" sites, in addition to the previous answer, or are ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)