Search results

Sorry for necroing the thread in advance but I have a question on WHEN/WHERE should I run the `CompactBE` sub? I have made my front-end to auto-close on 2 hours inactivity and considering it's only used by 3-4 users, chances of the back-end being locked (due to FE being opened) at 2am is very...

I have 3 queries which I need to combine in order to get the desired query. 1) Materials_Used 2) Products 3) Product_Operations 1) Materials_Used has the following fields: - ID - ID_Product - ID_Product_Operations - ID_Material - Quantity - Note 2) Products - ID - ID_Model - Name ... other...

Yes but I define the relationship for operation which change depending upon material. However, there are other operations which do not change depending upon article produced (ie. gluing will always use same material).

I could see how I would go around without having tblModelArticle (simply add a FK in tblArticle and assign models there straight away), but how would you go about not having tblModelOperation?

I thought this was all covered in:

Hello all! I was tasked to design a database for the manufacturing company I work and so would appreciate all the feedback I can get whether the current design structure could work (I'm very new to databases). So far I have identified 4 main datas - "Articles", "Models", "Operations"...

Hello all! I study computer science, however, I'm very, very new to databases and although I can understand code from several languages, I have no clue what is going on in databases :/. In my current work I have been tasked with creating a new database for the whole company... because you...