Grid data from multiple tables

[CGibson]

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

[HankFay]

Nice work.

Hank