Making a Subform Rollnrs

[dummy1]

Hello All,

I am not sure where to put this question.

But i am buillind a database Production planning.

Now i ve got the following want to integrating Qualities with RollID and RollLengths when the rolls got planned in a production the Rolls has to get out of my stock, So far i guess thats the easier step. Now i want also have the possibility to use a part of the rollength if so there should be a leftover

So i have Quality with Roll ID Roll Length A Roll Length B Roll Length C

Roll length A = Original length
Roll Length B = New length After taking a part
Roll Length C = New length After taking a second part

etc...

Now later on i want to have the possibilities to find the roll completly
and for with production runs i ve used the complete roll.

I know its all looking like latin here, but i ve got a problem to make it clear.

Example I ve got a production run where i use

Production Run X Quality X with Rol ID X with Rol Length X1
Y Quality X with Rol ID X with Rol Length X2

Now i want to build up my database logical so i ve got to make some tables The Quality table already existing, but now not know verry well how to start. Can someone help me out please

Regards

Dummy

 

[Premy]

Well, it actually looks more like old egyptian, as it is ;-)

 

[dummy1]

Ok at least its not russian, maybe someone in her understand Egyptian

 

[Premy]

Ok, I didn't mean any offence, just that you're problem needs to be explained a bit better in order to have someone try to help u.

Regards,

 

[dummy1]

Hello Premy,

No Problem, no Offence just struggling here...

Ok I will try again

I ve made a database production planning for printing Carpets

Now i need raw Material (rolls) to print on from different Qualities

For Each customer order that i plan i need raw materials(rolls)
But Sometimes i dont need the complete roll i need just a part of it.

So Wat i try to add in my planning database is the link to raw materials (tables)

So i have a Order ID that is printend on a Quality ID with Roll ID with a certain length, i want to keep track of the roll lengths of my Quality, So every time i am planning a new Order i can see wich Rolls i still can Use in a List from A certain Quality. Even i want to see when i Cut parts of those rolls and for wich Order i did that.

Still Maybe Egyptian, but i want to find a way to setup the tables right so I can link that to my Planning Database.

Included my Table relationships at the moment without the stock controll

Thanks in advance

Dummy

 

[Premy]

Ok, do u already have a routine to automatically update your stock? In my DB's I normally do this by running a query on the total amount purchased of a given item, minus the total amount sold (or set apart) for that item. That way u're sure your stock is always up to date. What u sold, or set apart has to be in your OrderDetails table, not your Orders table. Your OrderDetails table has to be linked to your Orders table in 1 to many relationship (Orders being 1, of course). U might check out the Northwind DB to see how the orders and orderdetails setup works.

If u have this kind of setup the remaining qty in stock of your item will always be what's actually there. And thru your Orders table u can easily track down how much of what has been sold to whom.

HTH