Newbie question here:
4 tables: Projects, Shipments, Locations, Destinations
Projects may have Shipments sent to Locations, and Locations pertain to a Destination (e.g. Destination A has Location X, Y, think of it as a chain having multiple branches)
How do I create a virtual column in Projects which shows (as a list) the Destinations that have at least one shipment for the project in question?
I tried using Select but can’t seem to find the proper approach, still learning the ropes.
Would something like this be possible?
Thank you very much to the community and whoever may answer this!