Hi I have questions on Reference data source:
(1) What it is for?
(2) How to add it? I tried to add a reference data source to a main data source on a new form, even though I have the relationship specified on the tables, the relation doesn't show up.
Hi Yvonne,
There is a documentation where you can find more information reference data source docs.microsoft.com/.../reference-data-sources-for-forms
What do you want to achive with reference data source?
Thank you. I have a header/line form that header data coming from main header table and CustTable. On the "Line View", the first half of the form is part of the header data, and users want to be able to add any available fields in the header view to the line view, but when I right click on "Personalize this page" and "Add field", only the fields in header table show up, not fields from table related to the header table such as Customer. I am wondering is that because I don't have CustTable added as the reference data source under the main data source??
Have you added CustTable as data source to the form itself?
Yes I did. But when trying to add column, still only the fields in the main data source show up.
What is the link type between header data source and CustTable on the form?
Sergei, thank you for the reminder on checking the link type! I updated to "InnerJoin" and it works!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
