Forum Discussion
yaman123
Post Partisan
Post PartisanAdd a new column with a value from another table
Hi, This should be so simple to do but I am not getting the results I want. I would like to add a new column to a table I have created - Account Table. This table has one column - Account C...
yaman123Post Partisan
Post PartisanHi,
The relationship is one (Account Table) to many (Budget Table) . When I am using Related in a new column in the Account Table, it gives me an error and doesnt recognise the table or fields?
goncalogeraldes
Super User
Super Useryaman123 That is because the RELATED() function only works from the many to the one side. Try using the LOOKUPVALUE() function then.
Further documentation here.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes