Forum Discussion
elliottharrison
Microsoft Employee
Microsoft EmployeeRelated function returns blank value
My related function and other lookupvalue functions just return a blank value. I have set up a one to many relationship but it doesn't appear to do anything. Any thoughts?
elliottharrisonMicrosoft Employee
Microsoft EmployeeSo, I really need to work from the many side to the one side. All the existing graphs are on the many side and I'm trying to avoid re-creating the whole dashboard. I just need two columns on the one side and they are both 1 to many on the many side.
Here is a screenshot of some sample data I made to show the table structure:
I have the AccountName and Numbers in both SQL tables but I would like to leave them blank in the many table so that I can save processing power on my python Table since they already exist in the one table.
If what I'm trying to do isn't possible I can just code through it in Python it just won't be as effecient 🙂