Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 release wave 1 Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Hi I have tabla A with a relation to another table "Table B" This table contains filed that I use to filter table A. for examples
Key Realtion Table B
Key field01 field02 field03
TypeB01 True False True
TypeB02 False False True
My page has a field that should list all the records of table A where the field "field01" is true. for this i need to create a filter that acces to table B fields but I don't now how to do that. Is it posible? in SQL y resolved this in this way
Select * from tableA iner join TableB on (TableA."Realtion Table B"=TableB.Key) where TableB.field01 = true
Can this be done in Business central?
Business Applications communities