i have 3 data masters:
1. customers - contains User ID, First Name, Last Name etc
2. orders - contains User ID, Order Number etc
3. Carts - contains Order Number, Item Name, Price etc
I need to create a lookup = user enters first or last name and I show data grid from Carts master that shows all items user purchased. So i need to locate User ID -> search Order Numbers by user ID, then lookup all matching Items by Order Numbers.
Is this even doable?