Recent content by Ramnik

Thanks but we cannot use logic based on productId's because the product ids might be any text based or numeric based. It was just filled for understanding purpose. Moreover the Raw Products and final products are mapped in many to many manner. Means there might be 2 or more rawproducts which...

Its Order1RawStock and Order1FinalShortage.

As the total order quantity is 20 for A13 the shortage will be 20 coz we have 0 pcs left in stock. A12 shortage will be 15 . It wouldn't add up coz we need to make 15 for A12 and 20 for A13.

Yes. Please guide me.

Its one to one . Its not actual raw material its raw product i.e. semi-finished product . For example . In a manufacturing process which consists of many processes until final product is made. In that early processed parts can be used in 2 or more final products . But mapping will be one on...

Its not as simple as that. How would you map the raw products with final products and fetch the stock accordingly????

The Shortage is calculated in two levels. Actually the Raw product can be used to create 2 or more different final products. So we need to calculate the use of raw product based on priority i.e. if the raw product A1 once used in A11 , the quantity available for A12 will be less . In this...

Please find attached file for relations.

I have created this imaginary data to show my point. As the existing structure is too big to display everything. Tell me what structure you need i will send that. Do you need relationships between product tables & stock tables?

Hello Everyone, I have a production database in which orders are checked for shortages at different levels of production in which : 1 raw product can be fetched in 2 or more final products, Shortages are checked as per priority. Please see attached image for illustration. In this database i...

that was great . I forgot a week ago i changed the language settings thats why it happened. Many Thanks :)

Hello Everyone, I have a data entry form which have a date field. This field retains the existing date after the record is saved with vba after update event. Private Sub Form_AfterUpdate() Me.ProductionDate.DefaultValue = Chr(35) & Me.ProductionDate.Value & Chr(35) End Sub Almost after a...

Can anyone help me to achieve the required query mentioned above ???? Thanks

Thanks for reply. Actually I need to prioritize the orders . I can calculate easily by totaling the orders and getting the total order shortage. And there is no such issue of seeing all the information at one screen. I need to issue the required quantity order-wise (priority-wise) . single...

Thanks . But can you take a look at attachment and suggest me how should i go for it??? thanks.....