Re: Field to automatically put value depending on code entered in anot
- From: "Al Campagna" <alcampagna@msnewsgroups>
- Date: Fri, 5 Jan 2007 08:57:58 -0500
1st,
Your post has me confoosed...
Why would entering a bar code prevent your using my suggestion? It would also seem to
me that the barcode should contain a unique value that would define the Price and Desc...
why a manual ItemNo entry at all?
What field in this scenario will be responsible for determining the Desc and Price?
Please give a bit more detail. This is definitely do-able, we just have to establish
what the setup is, and what info does what.
And, a minor point... please don't delete previous responses from your replies. That
way, everyone can see the "flow" of the problem in the last post.
--
hth
Al Campagna
Candia Computer Consulting
Microsoft MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions
"Find a job that you love, and you'll never work a day in your life."
"1st Texas Sales" <1st Texas Sales@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E9377485-8F88-405E-AAE0-6035FD118D6D@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Multi-Field Primary Key
- Next by Date: Database Properties : Date Created vs DateCreated
- Previous by thread: Re: Field to automatically put value depending on code entered in anot
- Next by thread: Re: Field to automatically put value depending on code entered in
- Index(es):
Relevant Pages
|
