Creating an order form using one table and autocomplete

[Guest]

I have one table with product number, product description, and product price.
I want to create a simple order form in which I can enter the product
number(and it will automatically fill in the entire number as I type) and the
description and price will be pulled from the table automatically. How do I
do this? All the instructions I've seen explain how to do this with 2 or
more related tables - I only have one.\

Thanks

 

[Guest]

Have you tried the dlookup function in the after update event of the product
number field?

 

[John Vinson]

I have one table with product number, product description, and product price.
I want to create a simple order form in which I can enter the product
number(and it will automatically fill in the entire number as I type) and the
description and price will be pulled from the table automatically. How do I
do this? All the instructions I've seen explain how to do this with 2 or
more related tables - I only have one.\

Thanks

You need THREE TABLES.

Sorry, but you just do.

A table of Products contains information about products - the product
ID, the name of the product, a description, the price, etc.

A table of Orders contains information about orders - who ordered
what, when they ordered it, etc.

Since a given Product may be ordered many times, and a given Order
will often be for multiple products, you cannot store Order
information in the Product table or vice versa - you need a third
table to contain a list of all of the products comprising each order.

See the Northwind sample database Order form for a worked-out example.

John W. Vinson[MVP]