Help pls my forms wont work

• • Reply

  13 years ago

  by mark12345

  Mark Caine

  , United Kingdom

  Joined 13 years ago

  Hi folks, thanks for looking. I have a database that takes down order details.
  Each customer has there own priceid in the price table.
  the errors that I get say enter parameter value for:
  products.unit price
  Unit Price
  Discount Price
  
  
  
  
  

  Maybe a bit of history would help with this, the user said originally that they wanted to be able to give customers a discount on every line of stock.
  Then realised after completion that this is no good for there requirments. The only option is to give each customer there own price list.
  

  I have the structure
  tblCustomers
  CustomerID Autonumber and key
  then other non relevent field at the mo
  
  
  

  tblOrderDetails
  OrderDetaiID Key
  OrderID
  ProductID
  Quantity
  Price
  
  
  
  
  

  tblOrders
  OrderID Key
  CustomerID
  OrderDate
  PurchaseOrderNumber
  ShippingMethodID
  Payment Received
  Comment
  
  
  
  
  
  
  

  tblPrice
  PriceID Key
  ProductID
  Price
  CustomerID
  
  
  
  

  tblProducts
  productID Key
  ProductName
  Cost
  
  
  

  Im really stuck here, my form wont work

  The Record Source for the AddNewOrderandDetail form reads:
  SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate, Orders.PurchaseOrderNumber, Orders.ShippingMethodID, Orders.FreightCharge, Orders.PaymentReceived, Orders.Comment, Customers.Address FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID;
  The Record
  The Record Source for the AddOrderDetail is:
  SELECT OrderDetails.OrderDetailID, OrderDetails.OrderID, OrderDetails.ProductID, OrderDetails.Quantity, OrderDetails.Discount FROM OrderDetails; .
  
  
  
  

  I got to deliver this in the morning HELP PLEASE

  Thanks
  Mark
  
  
  

  Report abuse