Application to Filter Report Upon Entering SKU #

[kvt]

I am very new to Access and have been teaching myself at the same time as I make a database. I also am completely unfamiliar with VBA and Macro. While it would be helpful to read up on all that you can do with VBA and Macro, I am a summer intern returning to school shortly and I need to do something that seems fairly simple (maybe) to make my database more accessible and user friendly to my manager and coworkers when I leave.
My database contains multiple records of individual SKUs and groups of SKU #s that have an ID # that is the primary key for that table. And there are two tables, each with the settings for a specific ID # for different machines. I used a relationship and query to allow me to make a report for each of the two machines separately.
Now I would like to make it so that I can enter the SKU # into a form or application and it automatically pulls the two reports for the SKU # entered for the two different machines in print preview. Note that there are sometimes multiple SKUs per record in the same field “12345, 23456, 5432”. I would like for it to not have to match the entire field to be pulled up.
I appreciate any assistance that can be offered! Thanks

 

[Cronk]

It's fundamentally bad database design to put multiple values into the same field, for reasons you are starting to realize.

Create another table where the table has at least 2 fields, one holding each one of the multiple values and the other the key field in the other table.

If this process is not clear to you, advise the main fields in your current table(s).