web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Table relation to Option Datatype field

(0) ShareShare
ReportReport
Posted on by 20

Hi. Working on a new extension for my company to configure our products and store engineering data. 

In my top level table I am trying to reference the data of another table with component Engineering data. So the top level table uses a field that looks up the component ID (primary key). Then other fields in the top level are flowfields of Lookup type that pul other component data. It works fine for pulling numerical data (like amp draw) but it gives me an error when I try to pull data that I have setup as Option Data type. About half of the fields for component data are option type.

How does one reference data stored in Option Data types , if at all?  If I wrote a procedure for the OnValidate trigger for the primary key drop down, would that be able to reference that data using Find? 

I have also read that Enums are the newer and preferred method vs Option and OptionMembers. Would this work as an alternative? 

One last question, is there a way to limit the input with options at the Page level vs. the Table level? 

Thank you for taking time to read my question.

Regards,

Jeff Johnson

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    on at

    Hello,

    This is a duplicate posting. Please do continue here:

    community.dynamics.com/.../1035488

    Thanks.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans