I'm afraid that will not help me on this. Basically I am trying to setup as
a Point of Sale system. I will enter in the item number, scan the barcode and
need it to pull up the product and its set price.



"1st Texas Sales" wrote:

I have been using a invoice database to invoice my customers for a while and
now want to update it so that the product name automatically enters based on
the product number I put in another field. Example below.

Item Number field, I type in 101 and then the field of description would
automatically enter "Candy Bar" and would automatically enter the price in
the next field.

Anybody that knows hoe I would do this I would greatly appreciate the info.
Thanks