Recent content by asteropi

I did. Thank you so much. This forum is amazing when it come sto helping out beginners like me :D

fixed it thank you. It was a problem with the relationship of one of the tables

just a blank query. it doesn't pull any data this is the only criteria i put

nothing. it doesn't show anything. just a blank query

it seems the query has the problem and it's not working properly

yes you are correct

Hey guys, I need some serious help fast. So I have a system for an online shop. I have a form for the Orders which prints 3 reports. If the customer is wholesale but not paid yet, it prints a quotation If the customer is wholesalebut paid, it prints an invoice If the customer is retail, it...

forgot to take it off. it's fixed now thank you

I actually don't save all the details in the Batch tables. It's just for my reference in the form, but I only save ProductDetailsID and SupplyID

Exactly to the point

if it looks it up and for whatever reason I change suppliers, then the old batches will also channge suppliers, which I can't have. I need it to record the info in the batch table

I realized I needed to record the lot and supplier in the BatchT for historical records. So I made 2 fields there and had the command button add my info in that table instead Now I need to figure out how it will not input all the lots of one ingredient in the report This is the correct one

Never mind all. I fixed it myself.

I order supplies which have lot numbers, make the products which have batch numbers and sell to customers When I make the batches I have to record which lots I used from the product, so if I get a bad one and the manufacturer recalls it I will know where I used it. So I need to history record...