Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 658
André Arnaud de Cal... 468 Super User 2026 Season 1
Syed Haris Shah 333 Super User 2026 Season 1
