Help about storehouses

[Mehvan]

Hello Everyone



I didn't come to this website long time ago , because I didn't have many information about Microsoft Access
Now it's better , I have some information about Microsoft Access but not so much , because I didn't a programmer , How much we be good in Microsoft Access or other programs , I think we will need to help each others sometimes

I have a question about storehouse transfer to another storehouse
Now I have 4 storehouses , sometimes I will need to transfer some Items from storehouse1 to storehouse2 without using (price)
because just we're using transfer , we don't sale those Items ( storehouse , items , tons and quantity )
When I use storehouse1 automatically less than Items in storehouse1 and add to storehouse2

[ranman256]

use queries.
link in the tables from other storehouses and run an append query to transfer the records.

[Mehvan]

mean I should create one table for transfer Items between storehouses and I should use 4 an append queries
"storehouse to storehouse"
"Items to Items"
"tons to tons" and "quantity to quantity" , right ?

[aytee111]

I presume this is a form where you can select the product and select the storehouse (warehouse), enter a quantity and click Transfer. The question is, what do your tables look like?

If you have a transaction table which records all ins and outs for each product, then you would create (append) two records - one to subtract the quantity from the first product and the second to add the quantity to the new storehouse.
If you have one table per product or per storehouse then it would be subtracting the quantity from the first and adding it to the second.

[Mehvan]

Thanks aytee for your help

yesterday I worked about these storehouses but I can't to create it correctly , if you can help me more I will be very pleased

I'm trying to create a Factory database by Microsoft Access , here is We have Manufacturing company
It's needs to create software for that factory , and I don't have information about others Programming languages such as : ( SQL Server , MySQL Server , C# ..... ) so I want to create it by Microsoft Access now , I don't know , I will can create it by Microsoft Access or not

these are some information about that factory :

Here is we have 4 storehouses ( 1- Big Roll , 2- small Roll , 3- Pipes , 4- Stock )
We're buying only ( Big Roll ) 95% of some factories from other countries
I created all tables and Invoices
now only I need to create Storehouse transfer

this is my question about storehouse :

I have storehouse for ( Big roll , Small roll , Pipes and Stock ) because I should know how many kinds of these Big roll we have in storehouse and others storehouse in the same , Everyone is different from other.
But we should know here ( We create Small roll , Pipes and Stock at Factory )
We transfer Big roll to another storehouse even we create Small roll from that Big roll maybe we create 5 small roll from 1 Big roll and from Small roll we will create pipes and of course little time we will have a problems at factory in that time we will have few stock pipes

How I will can create these storehouses , When I transfer to other storehouse ?
Am I should use transfer or I should sale between these storehouses ?

this is the first software I will create to factory , If someone can help me , I will be very glad

[aytee111]

There was this thread, did you follow the instructions?

[Mehvan]

thanks a lot for your help, I will do it and of course it will be so useful