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

[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.

thank you

 

[JHB]

It could easily have been done if it had been planned from the beginning, but at this stage it is going to cost some efforts in editing tables, forms, queries, etc..
The only thing required was an extra field in the tables which indicate which store the different items/objects relate to.