I have a projects table with a report link (embedded report). This report is filtered based on a drop down that contains kit type. By selecting the kit type, the report shows a list of line items. I now need to limit the show/hide some of the line items based on another drop down. This kit table currently does not have a relationship to the project table.....what is the best method for accomplishing this filter. Just as a note there is no part type in the kit table so if I needed to do this by filtering part type, I will need to add that column of information
">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1630314/RackMultipart20170803-104940-1oklbp-Kroger_Lids_Part_List_inline.jpg?1501771407">
Thanks in advance!