You can't set up "OR" relationships, e.g. Product = A or ShipNum = A.
One option might be to make a calculated field in Table 6:
Product & ¶ & ShipNum
If you then put every Product and ShipNum that was clicked into a global field, you could use a relationship from the global to the calc field to display the records in Table 6. You could add the date range to the relationship too.
(Using a "select" field can be a problem in multi-user settings.)
Thanks for the suggestion. But wouldn't going from a global field to a calculation field cause the relationship to be an unindexed relationship? And how can you set up the relationship? 1 global field to the new field? Please advise. Thanks.
A global field works when it's on the parent side of the relationship.
Yes, one global field with both selected Products and selected ShipNums, related to the new field.