I have an Indented BOM BAQ that works fine within the Erp.PartMtl table. My bosses want to be able to see additional information about the part, so I wanted to add the following additional tables: PartXRefVend, PartWhse, PlantWhse, Part, and PartCost. I don’t want any filtering done by them, only want to display the information. However, no matter what I seem to try, it errors out my relationships between the tables, and I’m not sure how I’m supposed to do it.
What’s the error? On my similar BAQs I have the first subquery as an inner subquery on a different Top subquery. Then I do my joins for extra info on that table (building the indented BOM as you previously were)
I know originally I had an issue where it would tell me I couldn’t have an inner join on the recursive part of the query. Not sure what I changed, but when I test now, I receive this error.
I would make a new subquery and bring in Subquery1. Copy all the fields from Subquery1 to the Display tab. Then You can join those other tables to Subquery1. I can’t explain the errors but I know I have had headaches trying to join things in the wrong place on recursive BAQs. You may need to display extra fields from the indented BOM part of the BAQ in order to make the joins.
