I have an App that allows you fill a form, when you select certain fields, it automatically controls other fields, e.g Region shows you only the name of customers in that region in the Customer Name field. This I achieved by using one view from a Table and ask each field to reference a column from that View.
What I want to do now is allow one of the fields be linked to the previous fields (The 1st view) and also be linked to another view from another table. How do I achieve that? See below the flow
Pick Region(All Regions available show)
Pick Your name (Only Names from the Region above shows)
Pick Customer name (Only Customers belonging to the name above shows)
Pick Customer Ship To (Here I want all SHIP TO numbers belonging to the customer above to show- This Data is from another view/Table)
Pick Order Number (Here I want all ORDER Numbers belonging to the SHIP To above to show- This Data is from another view/Table)
The last two flows is where I have a challenge.
LinkedIn
Twitter
