From: Steve on
You're saying that ALL items in an order are shipped from a designated
warehouse. Is that correct? Do you have the same item in more than one
warehouse?

Steve
santus(a)penn.com


"dirtrhoads" <dirtrhoads(a)discussions.microsoft.com> wrote in message
news:0D7AB6E2-34F5-46BD-9304-21A6D7BB454D(a)microsoft.com...
> On my Orders table, I have a shipped_via combo box so that I can select
> the
> warehouse from the warehouse table...
>
> "Steve" wrote:
>
>> Can different items be shipped out of different warehouses to fill an
>> order?
>> If yes, where do you enter which warehouse is to ship each item?
>>
>> Steve
>> santus(a)penn.com
>>
>>
>> "dirtrhoads" <dirtrhoads(a)discussions.microsoft.com> wrote in message
>> news:4FEFD746-DDA9-4C4D-8F7F-D887B7122103(a)microsoft.com...
>> > Hello,
>> >
>> > I am creating a shipping and logistics database in Access 2007 to keep
>> > track
>> > of sales, inventory, shipping costs, etc.
>> >
>> > We have 4 warehouses that handle shipping to distributors. I am
>> > probably
>> > making this more complicated than necessary, but this is tripping me up
>> > in
>> > designing the query that I want... I have an orders table, order
>> > details
>> > table (Lists each product per order individually), a warehouse table
>> > that
>> > lists each of our warehouses (this could possibly increase in the
>> > future),
>> > a
>> > products table which lists each individual product, and a customer
>> > table.
>> >
>> > I need to track the inventory in and out of each warehouse per order
>> > and I
>> > just need help getting started.
>>
>>
>> .
>>


From: cardiamo agapimu on
Impossibile inviare o ricevere messaggi per l'account Libero (nadia.lici)
(2). Impossibile trovare l'host 'protezione'. Verifica che il nome immesso
per il server sia corretto.

Server: 'protezione'
ID errore di Windows Live Mail: 0x800CCC0D
Protocollo: POP3
Porta: 110
Protezione (SSL): No
Errore socket: 11001

"dirtrhoads" <dirtrhoads(a)discussions.microsoft.com> ha scritto nel messaggio
news:4FEFD746-DDA9-4C4D-8F7F-D887B7122103(a)microsoft.com...
> Hello,
>
> I am creating a shipping and logistics database in Access 2007 to keep
> track
> of sales, inventory, shipping costs, etc.
>
> We have 4 warehouses that handle shipping to distributors. I am probably
> making this more complicated than necessary, but this is tripping me up in
> designing the query that I want... I have an orders table, order details
> table (Lists each product per order individually), a warehouse table that
> lists each of our warehouses (this could possibly increase in the future),
> a
> products table which lists each individual product, and a customer table.
>
> I need to track the inventory in and out of each warehouse per order and I
> just need help getting started.