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.
8  1301 
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.
so do i need to add 3 tables then ??
1st floor, 2nd floor and warehouse ...
but those 3 table contains the same fields...
Just one table
[tbl stock location]
Fields:
ID, Product ID, Lokation, Quantity , etc etc
then you have good flexibility
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?
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
Thx well that's seems interesting
i'm still working on it
i wish i could see what you built :)
@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,total_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 ?
Separate table should solve your challenge.
Like i wrote in #4
Or maybe i have misunderstood you
Sign in to post your reply or Sign up for a free account.
Similar topics
by: arabub |
last post by:
I have an installation of Apache that apparently includes PHP (out of
the box Redhat 9.0).
If I make database calls to Postgresql, as what user is that call
going to be made? The user that...
|
by: nawfer |
last post by:
for to resize and copy original photos into a new directory and to use
for a thumbnail gallery on the web;
what is better: GD, Netpbm or imagemagick and why?
very thank
|
by: Brandon J. Van Every |
last post by:
What's better about Ruby than Python? I'm sure there's something. What is
it?
This is not a troll. I'm language shopping and I want people's answers. I
don't know beans about Ruby or have...
|
by: martijn |
last post by:
H!,
I'm testing things with Python with databases.
But I have one big question.
What is the 'fastest' database for the internet in combination with
Python ?
- with +/- 15 GB data.
- fast...
|
by: Vasileios Zografos |
last post by:
Ok, easy question.
Not caring about the variable scope what is better (i.e. possibly in
memory allocation etc)
int someVar=0;
for (int i=0;i<1000;i++)
{
...
|
by: Bura Tino |
last post by:
Hi,
Going forward, what's better to use
<td height="20">
or
<td style="height:20;">
|
by: Arjen |
last post by:
Hi,
Sometimes I see this:
(string)DataBinder.Eval(Container.DataItem, "Answer")
And sometimes this:
Eval(Container.DataItem, "Answer")
What is better (faster/performance) when publishing...
|
by: mistral |
last post by:
what encoding better to select when paste javascript or php code into
windows Notepad and 'Save as'? ANSI, Unicode, Unicode big endian, UTF-8
?
m.
|
by: Rolf Mander |
last post by:
What performs better, theoreticaly?
This
<?
echo date("d",time());
echo date("m",time());
echo date("Y",time());
?>
Or that?
<?
$time = time();
|
by: ManicQin |
last post by:
Let's ignore for a minute design decisions , readability and any other
of those parameters , In the most raw form of c++ (purely efficiency
if you want)
what is better, bloating up a classes or...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
