Access a 2nd Table via Portal
I have a DB including two tables. The first is a list of people and the 2nd a list of products associated with the individuals from the 1st. They are artists with a separate table of artwork. In the Artists' table is a portal displaying all the work they have submitted. Some have only one piece, others a dozen or more.
Is there a way to click on an item in the portal and have it take me to that particular item in the 2nd table? In other words, I would rather not 'edit' the item in the portal, but click on it to take me to the full record of the item in the 2nd table. Hope that makes sense.