generating a seriel of serial no

[pwys]

Hello to everyone out there.
Would appriciate if anyone can helo me with this issue.

I am desiging a simple db for my store and would like to generate a serial
no for my products.

Product Table

Product Code Product Description Packing Size
A100-1 Product test 1 45
A200-1 Product Test 2 70

scenario:-

when i receive product A100-1 of 2500 and A200-1 of 3000;

Based on the packing size; i will get A100-1 = 55.5 and A200-1 = 42.8

i wanted to generate a series no of boxes (round up) into a transaction
table display below:-

Serial No Product Code Qty
050801-A100-1-0001 A100-1 45
050801-A100-1-0002 A100-1 45
...
050801-A100-1-0055 A100-1 45
050801-A100-1-0056 A100-1 25

050801-A200-1-0001 A100-1 70
050801-A200-1-0002 A100-1 70
...
050801-A200-1-0042 A100-1 70
050801-A200-1-0043 A100-1 60
Note:- the serial no will be reseted to 1 daily

your help is much approciated/

TQ

[Salad]

pwys wrote:

You know the requirements but your explanation of it is inadequate.

Did you write this as an exercise to waste people's time? See comments
below.

If you were asked for a advice by someone that wrote what you did, would
you comprehend what is required or would you be befuddled?

Hello to everyone out there.
Would appriciate if anyone can helo me with this issue.

I am desiging a simple db for my store and would like to generate a serial
no for my products.

Product Table

Product Code Product Description Packing Size
A100-1 Product test 1 45
A200-1 Product Test 2 70

scenario:-

when i receive product A100-1 of 2500 and A200-1 of 3000;
What is 2500, 3000?
Based on the packing size; i will get A100-1 = 55.5 and A200-1 = 42.8
Is 55.5 or 42.8 even relevent to your problem? If so, why? And where
do you "get" the figures?

i wanted to generate a series no of boxes (round up) into a transaction
table display below:-
55.6 = 56. 42.8 = 43. Round up to what?

Serial No Product Code Qty
050801-A100-1-0001 A100-1 45
050801-A100-1-0002 A100-1 45
..
050801-A100-1-0055 A100-1 45
050801-A100-1-0056 A100-1 25

050801-A200-1-0001 A100-1 70
050801-A200-1-0002 A100-1 70
..
050801-A200-1-0042 A100-1 70
050801-A200-1-0043 A100-1 60
What is 050801?

Note:- the serial no will be reseted to 1 daily
What do you mean by that.
your help is much approciated/
If you can't explain the problem, how do you expect someone to provide
advice?

TQ