cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CurtJanus
Level: Powered On

Editform item filter on Dropdown of related entity

Scenario:

 

On a single Screen...

 

Dropdown box or Combo box of Dog names from my tblDogs entity.

   Search field - DogID autonumber field? tblDogs field with the long string of charactors?

 

Editform1 of Dog details also from tblDog entity.

 

Editform2 of Dog Walks of the related entity, tblDogWalks. Related as Many-to-One by field XdogidX. A name that's easy to find.

 

I'm able to create records and keep them synced using Relate and LastSubmit.

 

Everything I see describes how to use a Gallery's ThisItem.Selected for Item in the EditForm and from the same entity.

 

So, when I select "Fido" from the DropdownBox or ComboBox, not a Gallery, how do I get the related records in both EditForms? The One Dog in EditForm1 and the Many DogWalks in EditForm2?

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
CurtJanus
Level: Powered On

Re: Editform item filter on Dropdown of related entity

Figured it out...

 

LookUp(tblDogWalks, XdogidX.DogID = cbbDogs.Selected.DogID)

 

with the DataSource being tblDogWalks

 

Works perfect!

 

View solution in original post

2 REPLIES 2
CurtJanus
Level: Powered On

Re: Editform item filter on Dropdown of related entity

Figured it out...

 

LookUp(tblDogWalks, XdogidX.DogID = cbbDogs.Selected.DogID)

 

with the DataSource being tblDogWalks

 

Works perfect!

 

View solution in original post

CurtJanus
Level: Powered On

Re: Editform item filter on Dropdown of related entity

perfectly

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Users online (3,430)