Search results

When making a batch it is important to record from which manufacturer you got the ingredient as well as which lot you used. So I need to have them on the form

Hey all, Once again I turn to you for assistance. I have a problem I do not understand I have a form to record batches of products made. The indgredients I get from a drop down menu. Menu has the supply name-colour-manufacturer-lotnumber When I get the ingredient, it seems it gets the name from...

Fixed thank you

Ok I fixed this problem but now there is another one Even though it takes all the data I input, if I close and reopen the form, the Batch Details don't show, even though they are saved in the table

That was also a leftover which I deleted now. I also allowed the data entry but I still get the same error as before I fixed all the controls and deleted any leftover commands that didn't make sense and compiled the database

I don't know what you mean or how to fix that

I don't know how to change the form name to compile this part

I deleted that. I had accidentally left it there

yes indeed

I wanted to change the file but I accidentally deleted the whole reply so I have a new error and I don't now what it is. If I press Add, it takes the supply info (SupplyT), supplier info (SupplierT) but it won't find the Lot Number and it gets stuck.

No it highlights the SupplyName for me and then it says it can't find LotNumber in table with LotNumberID

I was talking about a combo box in a form

Is there a way to refresh the Purchase List Form if I close the Purchase Form?

I went with the category solution

I found how to choose the different materials. The problem is that when it goes to store it in the purchase details it recreates inputs, like it's a new material

That would make it very hard to find what I'm looking for when checking them on the list

So I have a Supplies table which is my non-cooking materials like bottles, jars etc And I have an Ingredients table which is my cooking ingredients like oils, butters etc And I have a Purchases Table where I input what purchases I make for the company. How can I set it that when I purchase an...

wow this works perfectly! I manually changed a lot number (say it's from supplier) and then the next one picked up from the previous one. I now have to study to understand what you did

oh I didn't think about that. I will input the lot from other suppliers manually yeah, since they don't match my system. heck, I don't know what's the best solution here. what do you suggest is the best choice?

wow you fixed it!! but it's too advanced for me to understand what you did. can you explain it so I can learn?