Hey guys. I created the tables and columns in Data Verse. They are with the relationship, and I also have a lookup column pointing to them.
Everything is working, so much so that I've used them in calculated fields.
However, in the Canvas application, I'm having trouble displaying some data in the gallery.
I want to display the Orders - which are in the orders table. However, I also need to display the name of the Customer who placed the order - the information is in the customer table. And the name of the purchased product - the information is in the product table.
I can even use the Product table, and find the name. However, it assigns to the wrong record, and only passes the name of a product. The rest registered remains unnamed.
The Customer table does not even appear to be selected.