i am using a desktop inventory template and i would like some help in creating multiple stores

[james7705]

hi all

im am using the microsoft access desktop inventory template at the moment

what i have in mind to do is create another store with the same inventory, but i would like to merge it into the current database that i am using.

in other words ... i have 2 stores.

i have the same inventory in each.

i would like to be able to add and remove inventory from either store without affecting the other store



i would also like to see stock totals etc for each store

i would also like the option of being able to add another store at a later stage if the need arises

is this possible?

how would i go about doing this?

please find attached a sample of what im currently using.

Desktop Inventory.zip

thank you

[orange]

Without looking at your structure/database, you need a method to differentiate/discriminate 1 store from any other.
Could be as simple as a StoreID?

General query along these lines:

Select * from Inventory where storeId = XXX

[james7705]

So do I create another table? For the store names? With a one-to-many relationship?
Between the inventory table and the store names table? How would my form layout be on this to input transactions?

[orange]

Possibly. I was giving a logical requirement/solution to your question.
Basically, if you have an application that works for 1 store, and you want to extend it so that it can handle multiple stores, then you need a means to identify each store. So each store has its own unique identifier, and data in every related table within the database has to be identifiable as to the proper store.

Now, if you had 3 copies of the same database, you could use a copy in each store. And as long as the data can remain separate, you would not need to do all of this within 1 database.

In plain English, how do the three stores relate? To proceed in any direction you need a clear statement of requirements.

Good luck.