what's the better way to do that database ?

[hannoudw]

i'm doing a stock inventory and sales, etc...
my database contains these tables:
items, order, order details, person, type person, invoice, invoice details. but i have 3 stocks , otherwise saying i have 3 places where i can store the items. for example (in the 1st floor of the shop, in the second floor of the shop where is sold, and in the warehouse).
so i can add a field to the table item with the type check box contains these 3 .
or i need to add a new table?
i'm new in access and i need some help please.

[munkee]

I would add a new table as it is easier to update the extra table with a new value if you end up needing to expand in the future than it is to go through and change everything. Also for integrity I would be doing the same anyway.

I read somewhere that if you are in doubt about whether to create an extra table or not it is always best to just create it. Fewer problems in the long run in my opinion.

[hannoudw]

so do i need to add 3 tables then ??
1st floor, 2nd floor and warehouse ...
but those 3 table contains the same fields...

[MrDeej]

Just one table

[tbl stock location]

Fields:
ID, Product ID, Lokation, Quantity , etc etc


then you have good flexibility

[hannoudw]

yes but my database contains these tables:
items, order, order details, person, type person, invoice, invoice details.
so that mean that i just need to add the field Location to the items table right?

[MrDeej]

Yes you can add the field [location]

This however limits you to 1 location pr product.

I have built a similar system, but with 900 products and 3500 locations :=). Each product can be at uppto 20 different location inside our production

[hannoudw]

Thx well that's seems interesting
i'm still working on it
i wish i could see what you built :)

[hannoudw]

@MrDeej
well your idea was a good one
but i dont think it will solve my problem.
i'm doing a stock on shoes
so the item(article,to tal_stock,and stock quantities of every size of the article)
so if i add a field to the item table that means that all the size of the article will transfer from this shop to another one for example.
but i need to be able to send the quantity that i need from that article to any store that i want !??
how can i do it ?

[MrDeej]

Separate table should solve your challenge.
Like i wrote in #4

Or maybe i have misunderstood you