BUILD MANY STORES

[Safari]

HI

HOW TO BUILD MANY STORES IN MY DATABASE AND TRANSFER ITEMS BETWEEN THEM ?

WHATS THE STEPS ?

THANKS

 

[arnelgp]

not exhaustive:

tblStores

StoreID (autonumbr) PK
StoreName (short text)
LocationID (long integer) FK


tblLocation

LocationID (autonumber) PK
Location (short text)


tblItemLocation

StoreID (long integer) FK
WhsID (autonumber)
Descriptiion


tblItems

ItemID (autonumber) PK
Description (short text)

tbItemTransfer

TransID (auto)
TransDate (date/time)
ItemID (long)
FromWhs (Long)
ToWhs (Long)
Quantity (double)
Remarks (short text)

 

[Minty]

Multi-site inventory is not a trivial subject. Even experienced developers often shy away from it.
What is your initial design, what are the constraints.
Do you have a current stock list? What does it look like?

 

[Safari]

not exhaustive:

tblStores

StoreID (autonumbr) PK
StoreName (short text)
LocationID (long integer) FK


tblLocation

LocationID (autonumber) PK
Location (short text)


tblItemLocation

StoreID (long integer) FK
WhsID (autonumber)
Descriptiion


tblItems

ItemID (autonumber) PK
Description (short text)

tbItemTransfer

TransID (auto)
TransDate (date/time)
ItemID (long)
FromWhs (Long)
ToWhs (Long)
Quantity (double)
Remarks (short text)

thanks
you are the best