-
I was able to obtain data from a third table using nested keylookup.
For future reference, here is what I used:
First test - display the customer id in the order details grid - customer id was an added blank dummy column to the table:
Choices: select customerid from orders
Get Data Mapping: keylookup("orders", "orderid_search", order_details.orderid, customerid)
Second test - display the contact name in the orders grid - contact name was an added blank dummy column to the table:
Choices: select contactname from customers
Get Data Mapping: keylookup("customers", "customerid", orders.customerid, contactname)
Finally, combine the above two get data mapping sections.
(using order_details to display then contact name - contact name was an added blank dummy column to the table)
Choices: select contact name from customers
Get Data Mapping: keylookup("customers", "customerid", keylookup("orders", "orderid_search", order_details.orderid, customerid), contactname)
Cory
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks