G
Guest
I have downloaded template 01018547 (For customer orders) from Microsoft.com.
For the most part it is what I need. There are a few things I have been
trying to update/change to more readily meet my needs. The database contains
the following tables (fields listed too):
Customers Table: Customer ID; Company Name; First Name; Last Name; Billing
Address; City; State/Province; Zip Code; Website; Phone Number; Fax Number;
Ship Address; Ship City; Ship State/Province; Ship Zip Code
Employees Table: EmployeeID; First Name; Last Name; Title; Work Phone
Order Details Table: OrderDetailID; OrderID; ProductID; Quantity; Unit
Price; Price (this is a calculated field, multiplies quantity and unit
price); Discount
Orders Table: OrderID; CustomerID; EmployeeID; Order Date; PO Number; Ship
Date; Shipping MethodID; Sales Tax Rate
Our Company Info table: SetupID; Company Name; Address; City; State; Postal
Code; Phone Number; Fax Number (I don't have any issues with this one at this
point)
Payment Methods Table: Payment MethodID; Payment Method
Payments Table: PaymentID; OrderID; Payment Amount; Payment Date; Status
Credit Card #; Cardholder Name; Card Exp Date; Payment Method ID; Credit Card?
Products Table: ProductID; Product Name; Unit Price
Shipping Methods Table: Shipping MethodID; Shipping Method
Okay, now that that is out of the way, here are my issues:
1. I have a form called "Add an Order & Details" which includes a subform
called "Order Details". I have updated the subform so that when I double
click on the Product field it opens another form in a small window so that I
can add a new product and the price per unit. When I close the small window
I am then able to select the new product from the combo box which is the
Product field, but the price per unit does not change. How can I fix this?
I also need the price field to update (keeping in mind that this is a
calculated field). The query for the form is as follows: From the Orders
Table: Customer ID; EmployeeID; Order Date; Purchase Order Number; Ship
Date; Shipping MethodID; Sales Tax Rate; from the Order Details Table:
OrderID; Product ID; Quantity; Unit Price; Price; Discount
2. I need to add a Seriel Number Field to one of the tables and include it
in the above subform. Which table should I add it to?
3. Keeping with the "Add an Order & Details" form, I have set up the
Customer field on the form similar to the Product field in the subform.
Double click on it and it takes you to another form to input information for
a new customer, close this form and you are returned to where you were. When
I double click on this field to add a new customer I get a message saying
Customers.ShipPhoneNumber. This should not be popping up, I have deleted the
field from the table it was in and the form for inputting new customers. How
do I get rid of it?
These are the questions I have for the moment. Any help would be greatly
appreciated. I am sure that once I have these issues taken care of I will
come up with more regarding reports I will need to generate.
Thank you so much in advance for any help that any one can give me!!
Teri.
For the most part it is what I need. There are a few things I have been
trying to update/change to more readily meet my needs. The database contains
the following tables (fields listed too):
Customers Table: Customer ID; Company Name; First Name; Last Name; Billing
Address; City; State/Province; Zip Code; Website; Phone Number; Fax Number;
Ship Address; Ship City; Ship State/Province; Ship Zip Code
Employees Table: EmployeeID; First Name; Last Name; Title; Work Phone
Order Details Table: OrderDetailID; OrderID; ProductID; Quantity; Unit
Price; Price (this is a calculated field, multiplies quantity and unit
price); Discount
Orders Table: OrderID; CustomerID; EmployeeID; Order Date; PO Number; Ship
Date; Shipping MethodID; Sales Tax Rate
Our Company Info table: SetupID; Company Name; Address; City; State; Postal
Code; Phone Number; Fax Number (I don't have any issues with this one at this
point)
Payment Methods Table: Payment MethodID; Payment Method
Payments Table: PaymentID; OrderID; Payment Amount; Payment Date; Status
Credit Card #; Cardholder Name; Card Exp Date; Payment Method ID; Credit Card?
Products Table: ProductID; Product Name; Unit Price
Shipping Methods Table: Shipping MethodID; Shipping Method
Okay, now that that is out of the way, here are my issues:
1. I have a form called "Add an Order & Details" which includes a subform
called "Order Details". I have updated the subform so that when I double
click on the Product field it opens another form in a small window so that I
can add a new product and the price per unit. When I close the small window
I am then able to select the new product from the combo box which is the
Product field, but the price per unit does not change. How can I fix this?
I also need the price field to update (keeping in mind that this is a
calculated field). The query for the form is as follows: From the Orders
Table: Customer ID; EmployeeID; Order Date; Purchase Order Number; Ship
Date; Shipping MethodID; Sales Tax Rate; from the Order Details Table:
OrderID; Product ID; Quantity; Unit Price; Price; Discount
2. I need to add a Seriel Number Field to one of the tables and include it
in the above subform. Which table should I add it to?
3. Keeping with the "Add an Order & Details" form, I have set up the
Customer field on the form similar to the Product field in the subform.
Double click on it and it takes you to another form to input information for
a new customer, close this form and you are returned to where you were. When
I double click on this field to add a new customer I get a message saying
Customers.ShipPhoneNumber. This should not be popping up, I have deleted the
field from the table it was in and the form for inputting new customers. How
do I get rid of it?
These are the questions I have for the moment. Any help would be greatly
appreciated. I am sure that once I have these issues taken care of I will
come up with more regarding reports I will need to generate.
Thank you so much in advance for any help that any one can give me!!
Teri.