Creating an order and storing it

[chang]

Creating an order and storing it


I want to create an order, so the person picks name from one table,
cutomer
from second table, and

then products from third. and then saves it, exactly like the northwind
database, but i have one

problem the price varies each time the order is placed, so how do i
store
it that way. My cas eis

that im a middleman when i get an order i see how much it will cost me,
and
then i decide how much

to charge. but it varies each time, and i nead it to save my cost and
the
amount im charging. how

would i go about this. thank you

 

[chang]

Thank you. I have a couple of problems how can i create a field in a
query if it doesnt come from a table, it automatically changes it to an
expresion. also im not clear on the steps following that, can you please
explain everything clearer or in a step by step. Im pretty new at this.
thank you

The 3 tables you are using should have 3 identical fields.
Create a query that contains your 3 tables ,linked with the 3
identical fields. Instead of using the "price" field from your product
table,create a filed in your query like this - ChargePrice:'' Now
create a "Make Table Query" - This will be the table where your orders
will be stored, so save the table as "Orders". Use the form wizard and
create a form from your Orders table. Save it as "frmOrders"
Now save your query as an Append Query (qryOrders) that updates to the
"Orders" table. In the criteria field, refer to the "frmOrders" form -
e.g. under product field type in [frmOrders].[Product] Create a
command button on your "frmOrders" form that will run the Append Query
(qryOrders) This will append the data you have captured to the
"Orders" table


Hope this helps, if not let suknow.
Ta
Theo

Creating an order and storing it


I want to create an order, so the person picks name from one table,
cutomer
from second table, and

then products from third. and then saves it, exactly like the
northwind database, but i have one

problem the price varies each time the order is placed, so how do i
store
it that way. My cas eis

that im a middleman when i get an order i see how much it will cost
me, and
then i decide how much

to charge. but it varies each time, and i nead it to save my cost and
the
amount im charging. how

would i go about this. thank you

 

[chang]

Also i got this error : Resultant table not allowed to have more than
one AutoNumber field. Error 3090

The 3 tables you are using should have 3 identical fields.
Create a query that contains your 3 tables ,linked with the 3
identical fields. Instead of using the "price" field from your product
table,create a filed in your query like this - ChargePrice:'' Now
create a "Make Table Query" - This will be the table where your orders
will be stored, so save the table as "Orders". Use the form wizard and
create a form from your Orders table. Save it as "frmOrders"
Now save your query as an Append Query (qryOrders) that updates to the
"Orders" table. In the criteria field, refer to the "frmOrders" form -
e.g. under product field type in [frmOrders].[Product] Create a
command button on your "frmOrders" form that will run the Append Query
(qryOrders) This will append the data you have captured to the
"Orders" table


Hope this helps, if not let suknow.
Ta
Theo

Creating an order and storing it


I want to create an order, so the person picks name from one table,
cutomer
from second table, and

then products from third. and then saves it, exactly like the
northwind database, but i have one

problem the price varies each time the order is placed, so how do i
store
it that way. My cas eis

that im a middleman when i get an order i see how much it will cost
me, and
then i decide how much

to charge. but it varies each time, and i nead it to save my cost and
the
amount im charging. how

would i go about this. thank you