How do I integrate three sheets together?
I’m trying to design a new sheet structure and need some ideas. Let’s say for example I have one table that has Computers and another table that has Applications. A third table (App Records) contains a reference to both on a one to one basis. Each computer has multiple applications and each application is linked to multiple computers. Each line in the App Records sheet has a pointer to the related computer and related application.
I want to be able to create a form in Computers that shows all the Applications for that PC.
Lastly, I want to know if there are any limits to number of Applications which can be associated or displayed for the Computer. I have a listing of 8k computers, 15k applications and around 120k app records (although that number can be reduced if needed).
Help Article Resources
Check out the Formula Handbook template!