Search results

Okay I'm little confused about how I am going to go about this. When an Order is created based on whats in stock. So if quantity of stock is 10 and I order 11, within my form it will automatically be placed as Quantity - 10, Quantity To Follow will be 1. My boss wishes for some sort of...

Okay the Processed Orders is combination of Orders and Orders details. The process orders also contains prices from Unit price, Discount, Charge and total price. This table is mainly just for reference to look at, it also contains quantity ordered and quantity to follow. This will be used later...

Order ID help/question *SOLVED* Hi all, hopefully this will make sense as I type it out. I currently have an purchase orders database which is working fine. When an order is created through my form the details are stored in 2 tables 'Orders' & Orders 'Details'. Both are linked with an Order ID...

Yes, I did read the post and I thought I might have fixed it to work, but I was wrong. Anyway I did finally fix it anyway.

I'm not sure where its going wrong then. I mean I have Subtotal - 115.34 VAT - 23.07 Charge: 0.00 Total: 138.40 it seems to be a penny out. I have VAT - =Round(Sum([Extended Price]*1.2-[Extended Price]),2) Total - =Round(Sum([Extended Price]*1.2-[Extended Price]+[Extended...

Hi all I currently have =Round(Sum([Extended Price]*1.2-[Extended Price]),2) however I want to Int instead because of the third decimal place.

Hi I tried your database you sent back, but it didn't appear to work. When I clicked on the product code it altered the product title, but still hasn't changed the price. I don't need that code stored within the table, I just need it to update the price and product name within the form.

Sorry about this. I'll try again

Try this now. Not sure how I keep breaking this database.

Posted a copy

Hi Bob, once again I have managed to break the database you sent me. I added in a new dropdown box with Product code, because orders will be placed on either product name or product id. When I pick an item this works fine, however there is no price being generated now. Any chance you take a look?

I do really appreciate this! If you ever need a website building let me know!

Hi, I think I may have caused a problem with the database you sent me. I changed the product ID from a digit to the actual sku as it should be however. I am now getting a debugging message and don't know what to changein order for it to work correctly

Its okay I think I have figured it out now.

unless a query based on whats currently in to whats been ordered?

I believe so yes. But if I wish to update the quantites on a website. how would that work in terms of not storing a the available quantity?

Thank you so much for this! It works perfectly just how I want it. I really do appreciate this.

Hi sorry to bother you again. My manager now just asked me even though we have individual discounts on individual products for each customer. He now wants to know if you can apply a bulk discount on items, as well individual items. So Customer 1 gets 10% on Product A, however if Customer 1...

Thank you for doing this my its complete! Could you tell me what you did in order for it to work just in case for future reference. And thank you once again, as for the debit of stock, we do that because we also have a couple of websites to update with that quantity as well you see.

Thank you for doing this. However when I select the second product with Cus 2. The discount doesn't seem to be updating, its just remains the same as the first discount.