forms?

D

debbiejj

I am writing a database. I want to have a form that has 4 columns. When I
input a porduct number in column 2, I want that product numbers description
to appear in column 4. How should I do that?
Thanks-
Have a great day,
Debbie
 
S

Steve Schapel

Debbie,

The first assumption to be made here is that you have a Products table
of some sort, where the ProductNumber of all the products, and their
associated Description, are listed. Does this apply? And then we would
assume that the Form which you mentioned primarily relates to another
table, right? And in that other table, there is a ProductNumber field,
right? But the other table does not contain a Description field, does
it? (If it does, it is probably not a correct table design).

Ok, there are several ways to approach this. They are explained int his
article...
http://accesstips.datamanagementsolutions.biz/lookup.htm
Please post back with more details if you need more explicit help.
 
D

default105

Well, excuse me here if I lose you. I did a similiar thing back a while ago
when I made a database for work orders.

I am assuming that you have 2 tables and just for ease one will be called
table1 and the other table2. table1 would have your product numbers and
descriptions. And table2 has the other information that is relating to your
particular use.

You need to create a select query with both tables in it. Add the part #
field from table2 to the query and and product description from table1. Make
sure both field names have the same name in both tables. Join the two tables
and in the join properties gui add your one table on the left with the
product # field in the Left Column Name and the other table on the right with
the product # in the Right Column Name. Select the option for Only include
rows where the joined fields from both tables are equal.

All this information I got from the access help and a access 97 bible.

Hope this helps
 
D

debbiejj

Thank you for your help. I do have a products table with the productnumber
and descriptions are listed. I havent associated the form w/ anything yet.
Its an order form that i havent done anything else with. I actually created
it in word orginially. and used form fields. The salesperson wants to input
the product number and have the associated descripton appear in the
description field of the order form automatically so he doesnt have to type
it.
Have a great day,
Debbie
 
S

Steve Schapel

Debbie,

Ok, that's what I thought. So it sounds like you need to create an
Orders table and an OrderDetails table for the data about the orders.
And then your forms will be related to these tables. Most likely the
functionality you have been talking about, with the ProductNumber, will
be to do with the OrderDetails, and this will most likely be represented
by a continuous view subform on the Orders form. But we are jumping
ahead here... normally it is a mistake to even let the word 'form' enter
your head until after you have your tables set up correctly.
 
Top