Microsoft Dynamics AX (Archived)

Manage mandatory field in OuterJoined form datasource

(0) Share

Report

Posted on by Community Member

Hi,

Here is my requirement :

DataSourceA with fields A.recId, A.Name, A.DataSourceBRefRecId

DataSourceB with fields B.recId, B.Name, B.someData (Mandatory on table lvl)

DataSourceB OuterJoin DataSourceA.

A.DataSourceBRefRecId can be empty.

When I update record in DataSourceA with A.DataSourceBRefRecId empty(0 in database), I got the errorBox : B.someData is mandatory.

How to avoid this ? I have no more idea of what checking. (I dont want to disable mandatory property of tableB.someData).

I hope this is clear, if not, I will be there to provide more informations.

Thx

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Rustem Galiamov 8,072 on at

Like (0)

Report

Hi Stephane M!

Can you provide some screenshots of the form and form DS properties?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here is some screenshots :

DataSourceA properties

DataSourceB properties

A.BrefRecId

If you need something else, tell me :)

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report

You may override validateWrite() method on DataSourceB and return true instead of super() or write some logic to return true if super() return false.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Not working :s

Always

(Translation :

Field 'CustAccount' is mandatory

Field 'CustGroup' is mandatory

Field 'Currency' is mandatory)

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Hmm..I've tried to do the same and it works.

Try to set breakpoint to the add() method of Info class and find the warning source.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Rustem Galiamov, Thank you a lot for the time you spend to help me.

Unfortunately, I dont have much time to spend for this and after some discuss with my colleagues we decided to bypass the problem by using a Views. (and it works perfectly)

Again thank you.

PS: the problem is not really solved but do you want I "close" the thread ?

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report

If problem not solved then the question should not be marked as verified.

Thanks.

Was this reply helpful? Yes No