I created a workspace (the default “all Items” workspace). I tried to create a new workspace and reuse two existing tables that have a relationship between them (a foreign key between them). If I drag and drop (or choose) the two tables, the workspace doesn’t show me the graphical representation of the existing foreign key. I noticed that I have to go and bring the foreign key constraint in order for the diagram to present it graphically. Is there a way to bring two tables and make TDM identify instantaneously that there is a relationship between those preexisting tables so that it will show graphically the two tables and the foreign key relationship?
Thanks in advance.