Hello,
I have a table that has vehicle information and the following fields: vehicle# and part#.
I have a prompt that gets one part number and for that part number, should get all vehicles# with the selected part. From the filtered vehicles, I'd like to have a prompt that gives me all associated parts where the user will be able to get a report with more information on those parts (from another dimension table). I've implemented it the following way:
(Query1) My first query prompts the user on one part# then gets associated vehicles#. Have vehicle#
(Query2) My second query gets all parts# associated (I have a filter that says vehicle# in query1). Have vehicle# and Part#
(Query3) I've created a joint query on query1 and query2. The joint query should have parts associated with selected vehicles#. Joined on vehicle#, gets associated parts#
(Query4) Then I do have my report query that should prompt the user on selected parts from the join query(Query3).
This is where I'm having an issue as I get all parts on the prompt and not those associated with the selected vehicles from Query1.
I hope I did not confuse you. I cannot have a cascading prompt as I do not have a hierarchy like relationship here.
Am I doing something wrong or is there a better way to do that? Thank you.