I've been trying to set up a database where I can link employees (they all have a specific nr) to their clients (same here). I have managed to create a client list with their info but now I don't know how to continue. Do I make a new layout in the same doc as the one for clients? Or do I make a new doc and then connect the two? ¨
For example I want to be able to look at:
nr 145 Josh (click on his name to get his info) and then be able to see his clients; 1 Amy, 4 Rick etc and their info. Any good ideas?