Prev: Importing of TABLES TO A BLANK DATABASE
Next: Limitations on WHERE Clause in lookup query for a table column
From: Naveed Pathan on 18 Dec 2009 10:11
dear friends i have a problem that i can't sort it out though i have tried
alot anyhow i am here to get help from you people the problem i have is

suppose if i have a serial of numbers and if i sell a particular serial out
of that so i want to know that which serial is in my hand for example

if i have serial from 1 to hundred and i sell number 88 so i want to know
that number 88 is no more availabe in the whole serial as it is sold out .

Note : i will be thankful if you people sort it out or give an ultinative
suggestion or solution for it thankx
From: KARL DEWEY on 18 Dec 2009 11:22
How are you storing the serial numbers?
How are you recording the sales?

Post your table structure with field names and data type. Post sample data.

--
Build a little, test a little.


"Naveed Pathan" wrote:

> dear friends i have a problem that i can't sort it out though i have tried
> alot anyhow i am here to get help from you people the problem i have is
>
> suppose if i have a serial of numbers and if i sell a particular serial out
> of that so i want to know that which serial is in my hand for example
>
> if i have serial from 1 to hundred and i sell number 88 so i want to know
> that number 88 is no more availabe in the whole serial as it is sold out .
>
> Note : i will be thankful if you people sort it out or give an ultinative
> suggestion or solution for it thankx
From: Naveed Pathan on 18 Dec 2009 11:45
ok suppose to be the purchases serial is like

Item Serial Start Serial End
Cobra 562400405500 562400405600


now suppose that i sold the product with serial

item serial Start serial End
Cobra 562400405560 562400405569

so i sold that ten products so what are the remaining and shouldn't suppose
to show the one i sold out.
thankx
"Naveed Pathan" wrote:

> dear friends i have a problem that i can't sort it out though i have tried
> alot anyhow i am here to get help from you people the problem i have is
>
> suppose if i have a serial of numbers and if i sell a particular serial out
> of that so i want to know that which serial is in my hand for example
>
> if i have serial from 1 to hundred and i sell number 88 so i want to know
> that number 88 is no more availabe in the whole serial as it is sold out .
>
> Note : i will be thankful if you people sort it out or give an ultinative
> suggestion or solution for it thankx
From: Naveed Pathan on 18 Dec 2009 15:15
a challenge isn't it yes it is


"Naveed Pathan" wrote:

> ok suppose to be the purchases serial is like
>
> Item Serial Start Serial End
> Cobra 562400405500 562400405600
>
>
> now suppose that i sold the product with serial
>
> item serial Start serial End
> Cobra 562400405560 562400405569
>
> so i sold that ten products so what are the remaining and shouldn't suppose
> to show the one i sold out.
> thankx
> "Naveed Pathan" wrote:
>
> > dear friends i have a problem that i can't sort it out though i have tried
> > alot anyhow i am here to get help from you people the problem i have is
> >
> > suppose if i have a serial of numbers and if i sell a particular serial out
> > of that so i want to know that which serial is in my hand for example
> >
> > if i have serial from 1 to hundred and i sell number 88 so i want to know
> > that number 88 is no more availabe in the whole serial as it is sold out .
> >
> > Note : i will be thankful if you people sort it out or give an ultinative
> > suggestion or solution for it thankx
From: Fred on 18 Dec 2009 16:05
For cases like your example you will need inventory tables which treat your
items individaully.

Presumably there are many units (with many serial numbers) whihc have the
same model number.

Here's an idea for your main tables:

ProductTable

Field: Product_ID Autonumber, primary key
Field: ManufacturerName
Field: ModelNumber


ItemTable

Field: Item_ID Autonumber, primary key
Field: Product_ID Integer (foreign key, linked to field of same name in
previous table
Serial Number

This sect table will ned a record for each individual part.




"Naveed Pathan" wrote:

> a challenge isn't it yes it is
>
>
> "Naveed Pathan" wrote:
>
> > ok suppose to be the purchases serial is like
> >
> > Item Serial Start Serial End
> > Cobra 562400405500 562400405600
> >
> >
> > now suppose that i sold the product with serial
> >
> > item serial Start serial End
> > Cobra 562400405560 562400405569
> >
> > so i sold that ten products so what are the remaining and shouldn't suppose
> > to show the one i sold out.
> > thankx
> > "Naveed Pathan" wrote:
> >
> > > dear friends i have a problem that i can't sort it out though i have tried
> > > alot anyhow i am here to get help from you people the problem i have is
> > >
> > > suppose if i have a serial of numbers and if i sell a particular serial out
> > > of that so i want to know that which serial is in my hand for example
> > >
> > > if i have serial from 1 to hundred and i sell number 88 so i want to know
> > > that number 88 is no more availabe in the whole serial as it is sold out .
> > >
> > > Note : i will be thankful if you people sort it out or give an ultinative
> > > suggestion or solution for it thankx
 |  Next  |  Last
Pages: 1 2 3
Prev: Importing of TABLES TO A BLANK DATABASE
Next: Limitations on WHERE Clause in lookup query for a table column