Bear with me. I'm self-taught at access and don't know all the lingo.
- I have a table (#1) that has vehicle, RPO (regular production option), and component.
- I have a query (A) that joins those three together to create a unique value, which looks like this: "Corvette - J56 - Front Rotor".
- I have another table (#2) with all the different Vehicle-RPO-Component combinations and whether we supply them or not: "Yes" or "No".
- What I would like to do is have a field in query A that presents the "yes" or "no" based on the vehicle/rpo/component field that's also created in that query. Is there a way to do that or is it impossible?
- Because right now the only way I've been able to get the results I want is to create a query (X) that joins the information and then create query (Y) that uses the results from query (X). I'm not sure that's a wise or optimal way to do it. I feel like I would have to run query X before query Y every time to make sure everything lines up.
Any help is appreciated before I spend more time fiddling around and getting nowhere. Thanks in advance.