"Sharing" two tables

[beavisny00]

I have two tables (Orders) and (Products).

Orders table has fields named: Order ID
Product Name
Catalog #
Price
Quantity
Total Price

Product table has fields named: Product ID
Product Name
Catalog #
Price

I have a form which includes fields from both tables - How do I select
one product and have the rest of the fields entered into the order
table, as well as calculate a total price based on the quantity
entered? Or is this not a function of a table?

Thanks!

[Bob Quintal]

be********@hotmail.com wrote in
news:11**********************@p79g2000cwp.googlegr oups.com:

I have two tables (Orders) and (Products).

Orders table has fields named: Order ID
Product Name
Catalog #
Price
Quantity
Total Price

Product table has fields named: Product ID
Product Name
Catalog #
Price

I have a form which includes fields from both tables - How do
I select one product and have the rest of the fields entered
into the order table, as well as calculate a total price based
on the quantity entered? Or is this not a function of a table?

Thanks!

No it's not a function of a table. It is a function of the form.

Since you failed to mention much I'll make an educated guess
that the form is for Order Creation. You have some method of
entering the catalog number into the Orders form It could be a
combobox, a listbox or simply a textbox. Before anybody can
suggest how you copy over the price from the product table once
you have selected the Catalog number you'll have to tell the
group how you are entering the catalog number.

BTW the Neither Product Name nor the Total Price should not be
fields in your orders table, as the first can be looked up from
the product table and the second can be calculated, in any
query, form or report where they are needed.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com