I'm building a Model Driven App. I know how to do this on a Canvas App but not sure on Model Driven App.
I have an issue where I have the following. Given the 4 tables. Company, Card, Card Detail, Employee
For every Employee, I assign it to a Company. So Company to Employee is One to Many
For every Card, I need to associate it with a Company. So Company to Card is One to Many.
For every Card Detail, I associate it with a Card. Also, each Card Detail has an Employee assigned. So the Card has the Company and the Card Detail has the Employee (for the Company) associated with it.
My question is when I create a new Card Detail, on my Lookup at the Employee, I ONLY want to show those Employees for the Company assigned to the Card. How can I filter?
Table Definition Example:
Company - Company Name
Employee - Employee Name
Company Name
Card - Card ID
Company Name
Card Detail - Card ID
Card Detail ID
Employee Name

Report
All responses (
Answers (