I am creating a Model Driven App. I know how to create a relationship between multiple tables to create a view. My problem is when I try to use the columns created in the view, created by the relationships between multiple tables, to populate the form. Can someone please help me to understand can this be done and how?
On the form page of the app II have fields that auto populate depending on the record selected. I can get a column to show in the view based on columns of a related table, but I can't get the column to auto populate the form field in a text area. Take for instance you have customer table as main view it comprises of key customer id, first name, last name. The relationship table is purchase it is comprised of purchase id, item, cost, customer id. The view is the customer table. On the form you want to populate text fields for customer id, first name, last name from the customer table. You also want item and cost to auto populate in text fields on the form from the purchase table.