I am trying to find out if there is a way to create a link, that when you click on it, it immediately brings you to/opens up a different table.
For example: I have a main spreadsheet with labels in Column 1, stating the type of promotional item we need. T-Shirts, Coffee Cups, etc. Then I have a separate table for each type of item. So a table for T-Shirts with info on each t-shirt order.
I want to be able to click on the word “T-shirts” from Column 1 in the main table, and have it open up the “T-Shirts” table with specific information on each order.
I understand how to link so it will show you the records when you expand the data field, but I want to actually GO to that specific table. I also noticed if I try to do this with just a single data field, then it links ALL of the data fields in the column to the same record. I want each record to be able to link to a different table.
I hope this makes sense! Please feel free to ask any additional needed questions. Thank you in advance for your help!