automatic display data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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

Duane Hookom said:
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

--
Duane Hookom
MS Access MVP



Dave said:
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
Click to expand...
Click to expand...
 
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.
Click to expand...

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]
 
Back
Top