I have a table, tbl_VehicleOrders, that I use for orders. On the form that I use, Vehicle Order Form, I have 3 separate fields (Pkgs1, Pkgs2, Pkgs3) that I enter different packages or N/A, all coming from the same table, tbl_pkgs. I have a parameter query, Unit List by Model, that I run to see the specifics of each unit based on the vehicle Model which includes the 3 separate fields.
For the rest of the fields that pull information from junction tables, I can add the field from the primary table so that the query displays the actual text instead of the PK value associated with the junction table. The problem I am running into however is with the 3 separate fields based on one table. I'm not sure how to get the query to display the text instead of the PK value.
I have included a copy of my db. If you open the Unit List by Model query and then enter Edge in the parameter box the query will run. If you scroll to the right you can see that all the other fields contain the actual text associated with that particular field, except for (Pkgs1, Pkgs2, Pkgs3). If I add the Pkgs field from the tbl_Pkgs table the query will only display what is in Pkgs1. I need the query to display text associated with each of those PK values.
Thank you.