automatic display data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 10 Jul 2006 13:15 GMT

I want to be able to lock a product description to a part number, so when the
part number is entered on a table the description will be displayed
automaticly

Reply to this Message

Duane Hookom - 10 Jul 2006 15:31 GMT

use a combo box with a row source like:

SELECT [part number] , [Part Number] & "-" & [PartDescription]
FROM tblParts
ORDER BY [Part Number] & "-" & [PartDescription];

Leave the bound column as the first and set the column widths to: 0", 2";
Column Count: 2

Signature

Duane Hookom
MS Access MVP

>I want to be able to lock a product description to a part number, so when
>the
> part number is entered on a table the description will be displayed
> automaticly

Reply to this Message

Dave - 11 Jul 2006 02:18 GMT

Sorry i did'n explaine real well.
I have a seperate feild for "PartNumber" and "Description"
I want to be able to enter the part number in the "Part Number" Field and
automaticly have the description displayed in the "Description" Field.
I know how to do this on a form but don't know how to do it on a table.

Any help would be apperaciated

> use a combo box with a row source like:
>
[quoted text clipped - 9 lines]
> > part number is entered on a table the description will be displayed
> > automaticly

Reply to this Message

John Vinson - 11 Jul 2006 02:31 GMT

>Sorry i did'n explaine real well.
>I have a seperate feild for "PartNumber" and "Description"
>I want to be able to enter the part number in the "Part Number" Field and
>automaticly have the description displayed in the "Description" Field.
>I know how to do this on a form but don't know how to do it on a table.

Storing the description redundantly in a second table is simply BAD
DESIGN.

It's not necessary; it wastes space; it risks having one description
in the Parts table and a different description in this table.

Unless you *want* to store it redundantly, for some reason you haven't
expressed, just "unask" the question!

If you want to see the description from the parts table in conjunction
with data from some other table, use a Query joining the two tables on
PartNumber.

John W. Vinson[MVP]

Reply to this Message