Forum Discussion
problem with relation between table (newbie)
i have relation like these. In table projectdata I canuse related to salesName but I cannot use related to projectsubdata (I try to typing but it show nothing ) And second problem ...
Anonymous , Based on what I got. Related can only be used from 1 side to many side. You can create new column on Many side .
You can try relatedtable for 1 side
example
sumx(relatedtable(projectData]),[Est Fee])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8