New to MS Access please help

%3CLINGO-SUB%20id%3D%22lingo-sub-2038503%22%20slang%3D%22en-US%22%3ENew%20to%20MS%20Access%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2038503%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%20%2Ctrying%20to%20make%20a%20POS%20cashing%20form%3C%2FP%3E%3CP%3E(I%20have%20a%20database%20table).%20I%20have%203%20fields%20(UPC%2CUPC1%2CUPC2)%20in%20the%20table%20with%20different%20codes.%20I%20would%20like%20to%20create%20a%20form%20that%20contains%20a%20text%20box%20and%20a%20list%20box%20when%20I%20input%20a%20code%20into%20text%20box%20%2C%20it%20will%20automatically%20search%20in%20UPC%20then%20UPC1%20then%20UPC2%20until%20getting%20the%20match%20record%20and%20input%20that%20one%20into%20list%20box%20Thank%20you%20so%20much%20for%20your%20time%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2038503%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2040471%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20MS%20Access%20please%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F920491%22%20target%3D%22_blank%22%3E%40hohai610%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20Daniel's%20advice%20is%20the%20most%20appropriate.%20Don't%20start%20over%20with%20a%20new%20effort%20from%20scratch.%20Find%20an%20existing%20application%20that%20does%20what%20you%20need%20and%20later%2C%20if%20you%20decide%20it's%20not%20adequate%2C%20then%20you%20can%20start%20designing%20a%20custom%20relational%20database%20application%20from%20a%20position%20of%20knowledge.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20the%20problem%20you%20describe%20is%20the%20result%20of%20an%20inappropriate%20table%20design--which%20is%20a%20very%20common%20mistake%20made%20by%20people%20new%20to%20using%20relational%20database%20application%20development%20software%20like%20Access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThree%20fields%20in%20a%20table%20called%2C%20%22%3CSPAN%3EUPC%2CUPC1%2CUPC2%22%26nbsp%3B%20are%20what%20is%20often%20called%20a%20Spreadsheet%20Style%20table.%20It%20comes%20from%20trying%20to%20create%20an%20Access%20table%20in%20the%20same%20way%20you%20would%20an%20Excel%20spreadsheet.%20I%3CA%20href%3D%22https%3A%2F%2Frogersaccessblog.blogspot.com%2Fsearch%2Flabel%2FProblems%2520With%2520Repeated%2520Columns%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Et's%20called%20a%20%22Repeating%20Group%22.%3C%2FA%3E%20Many%2C%20many%20people%20make%20this%20mistake%20so%20don't%20feel%20bad%20about%20that%2C%20but%20do%20invest%20enough%20time%20in%20learning%20how%20relational%20database%20applications%20work%2C%20and%20how%20they%20should%20be%20designed.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ELater%2C%20when%20you've%20had%20enough%20experience%20with%20a%20properly%20designed%20POS%20system%2C%20you%20can%20start%20over%20designing%20your%20own%20more%20valid%20relational%20database%20application%20and%20get%20a%20useful%20result.%20After%20all%2C%20your%20objective%20is%2C%20I%20assume%2C%20running%20a%20business%2C%20not%20becoming%20a%20database%20developer.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone ,trying to make a POS cashing form

(I have a database table). I have 3 fields (UPC,UPC1,UPC2) in the table with different codes. I would like to create a form that contains a text box and a list box when I input a code into text box , it will automatically search in UPC then UPC1 then UPC2 until getting the match record and input that one into list box Thank you so much for your time

3 Replies
I'm afraid I'm still not clear as to what your question is?

Also, instead of reinventing the wheel, have you done any searching for existing POS databases that you can simply start from? Such as

https://www.utteraccess.com/topics/1985964

@hohai610 

I think Daniel's advice is the most appropriate. Don't start over with a new effort from scratch. Find an existing application that does what you need and later, if you decide it's not adequate, then you can start designing a custom relational database application from a position of knowledge.

 

That said, the problem you describe is the result of an inappropriate table design--which is a very common mistake made by people new to using relational database application development software like Access.

 

Three fields in a table called, "UPC,UPC1,UPC2"  are what is often called a Spreadsheet Style table. It comes from trying to create an Access table in the same way you would an Excel spreadsheet. It's called a "Repeating Group". Many, many people make this mistake so don't feel bad about that, but do invest enough time in learning how relational database applications work, and how they should be designed. 

Later, when you've had enough experience with a properly designed POS system, you can start over designing your own more valid relational database application and get a useful result. After all, your objective is, I assume, running a business, not becoming a database developer.

 

@Daniel_Pineault 

Thank you so much 

You just give me a good idea to improve my knowledge and my business .