Access 2003

S

shelian1

I am a first time user of Access. I have created 3 tables. The 3rd table is
a inventory Ins & Outs for daily counts. If I enter a prod # into a field I
want this info to automatically pop into the next five fields from the
products table. This will stop me from having to enter the next 5 items
manually. Just like in a store when they scan an item it automatically pops
up the item name, cost & so forth. That is what I want my table & form to do.

Can you PLEASE help me!! Be gentle I am a new access user simple terms
please. I am teaching myself how to use this program. Thanks & Merry
Christmas!!

Shelia
 
M

mscertified

Unfortunately, you have not explained what you want very well. What are the 3
tables and how are they related?
Have you defined table relationships?
When you say " If I enter a prod # into a field I want this info to
automatically pop into the next five fields from the products table."
Are you talking about forms or tables?
I think I have figured out you have a products table and an inventory table
but what is the third table?
What forms do you have to update your tables and what form are you talking
about?

You should not be entering any product number, you should be choosing the
product from a list based on the products table.

In the spirit of Christmas, If you email your database to me I'll take a
look at it: covrambles at yahoo dot com

-Dorian
 
D

Douglas J. Steele

Sorry, but no, you don't want that.

Data should not be stored in multiple tables. All you should be storing in
your 3rd table is the Product Id, and no other product details.

Take a look at the Northwinds sample database that comes with Access. Look
specifically at the subform that holds the order details on the Order form.
Note how they've got a combobox that lets you select the product, and it
stores the Product Id in the appropriate field. The row source for your
combobox can include as many fields as you like from the Product table (and
you don't have to display them all when the combobox is open: you hide them
by setting the column width to 0 for the specific fields you don't want
displayed). If you want to know a specific column of the selected row in the
combobox, you can refer to the combobox's Column property. If you put code
in the combobox's AfterUpdate event, for instance, you can set other fields
on the form to the additional fields in the combobox like:

Me.txtDescription = Me.cboProduct.Column(1)

In this example, I'm assuming that the combobox is named cboProduct. I'm
setting the content of a text box named txtDescription to the 2nd column of
the selected row in the combobox (column numbering starts at 0)
 
S

shelian1

Sorry I didn't make myself very clear. 1st table is "Customers", 2nd is
"Product" & 3rd is "Inventory Transactions". When I enter a Product # in the
inventory transactions table (which I enter Ins & Outs daily) I would like
the next 4 or 5 fields to pull their info from the "Products" table. I have
the "Product #", Description, Warehouse #, Area # & "Op bal" set up in the
"Products" table. So I wish to enter into the "Inventory Transaction" table
just the "Product #" & the rest of the info is pulled from the "Products"
table to fill in the balance of the fields in the "Inventory Transaction"
table. Yes I have defined the relationship to each table. This is to happen
in forms & tables. I hope this helps. I will e-mail the file to you & thank
you for your help.
 
Top