web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Index for checkbox wit...

Finance | Project Operations, Human Resources, ...

Answered

Index for checkbox with empty value

(0) Share

Report

Report

Posted on by bois0155

260

Hi guys,

I have a table which allows multiple Items, but only one record can be primary.

I created an index which consist in Item and PrimaryItem field. However, the PrimaryItem field is a checkbox, and even when the value is No

it will trigger preventing the user to create a new record. Only one Primary Item field can exist.

How can I accomplish this? Is it validatedWrite() the only way?

Example:

Table

ItemId | Info1 | Info2 | PrimaryItem (Checkbox No::Yes)
Item1 | info | info | Yes

Item 1 | info | info | No

Item 1 | info | info | No

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi bois0155,

Yes. Modifying validateWrite looks like the only way out here. You can't create an index using any of the fields to achieve this requirement.

Was this reply helpful? Yes No
Verified answer

MuthukumaranAX 2,903 on at

Like (1)

Report

Hi - adding field to index which has default value (in your scenario No) is not suggested, but it is requirements then you can achieve this through validatewrite method

Thanks

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 611 Most Valuable Professional

#2

André Arnaud de Cal... 529 Super User 2025 Season 2

#3

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans