cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
365-Assist
Advocate II
Advocate II

Lookup option list based on result from another lookup in Model Driven App

I am building a Model Drive App with Schools and their campuses.

I have a Table of Schools. I have also have a Table of Campuses. There is a one to many relationship between Schools and Campuses.

 

School Table

School A
School B
School C

 

Campuses Table

School ACampus A1
School ACampus A2
School BCampus B1
School BCampus B2

 

I have created a Form called School Campus with 2 lookup columns.

  • School
  • Campus

 

After a School is chosen I only want in the Campus lookup to see the list of campuses for that school to choose from.

any ideas how to do this?

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
poweractivate
Super User II
Super User II

@365-Assist 

 

Using Related Records Filtering on the Form, this should be possible.

 

Apply filtering based on the [column] context

To apply filtering based on the [column] context on your custom forms or on custom lookup columns added to the standard forms, open the form and use the Related Records Filtering section to apply the [column] filter. You must set this for each lookup column that requires filtering based on the underlying [column] on a given row...


Additional reference: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/special-field-...

 

View solution in original post

1 REPLY 1
poweractivate
Super User II
Super User II

@365-Assist 

 

Using Related Records Filtering on the Form, this should be possible.

 

Apply filtering based on the [column] context

To apply filtering based on the [column] context on your custom forms or on custom lookup columns added to the standard forms, open the form and use the Related Records Filtering section to apply the [column] filter. You must set this for each lookup column that requires filtering based on the underlying [column] on a given row...


Additional reference: https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/special-field-...

 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (47,324)