Can Access auto fill info? I need this function for purchae order

[Guest]

I order the same items with long numbers over and over again. Can an Access
database fill in the number if I enter name info? thanks, Katy

 

[John Vinson]

I order the same items with long numbers over and over again. Can an Access
database fill in the number if I enter name info? thanks, Katy

Sure. Use a Combo Box on a Form; have the human-meaningful text as the
first visible column of the combo, and the long number as the (zero
width) bound column.

Take a look at the Northwind sample database Order form. It's storing
meaningless numeric ProductID's while the user sees the name of a
product.

John W. Vinson[MVP]