Manager mandatory but giving an error

Hi,

I am trying to set the fileds UID_PersonHead and UID_FirmPartner as mandatory in the table Person, but when Iset the MinLen of these fields equal to 1 I get an error saying "The column cannot be marked as mandatory field (MinLen>0) because table relation 'QER-T-FirmPartner'.". I have attached a screenshot.

Why this error? Can you help me to resolve this issue?

Thank you in advice,

Elena

Top Replies

Tomi Kääriäinen over 1 year ago +1

Hi Elena,
the screenshot is missing. Anyway I had no trouble in setting Person.UID_Firmpartner the MinLen to 1.
Please check the table relations. For example open in ObjectBrowser from the table DialogColumn…

0 Tomi Kääriäinen over 1 year ago

Hi Elena,
the screenshot is missing. Anyway I had no trouble in setting Person.UID_Firmpartner the MinLen to 1.
Please check the table relations. For example open in ObjectBrowser from the table DialogColumn UID_FirmPartner and choose the object relations. There should be only one QBMRelation.

Cheers,
Tomi Kääriäinen
Cancel
Up +1 Down

Reply

Verify Answer

Cancel
0 el romeo over 1 year ago in reply to Tomi Kääriäinen

Hi Tomi,

My settings are the same from yours. Do you have any other idea?

Thank you for your answer,
Elena
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Tomi Kääriäinen over 1 year ago in reply to el romeo

Hello Elena,

Is there also only one QBMRelation for UID_Firmpartner? My assumption would be that there is more than one QBMRelations defined for the column.
Otherwise use more logging to find out the issue or check the relations for the table Firmpartner, if you notice something. I'm quite sure that there is some custom relation that is interfering. You should be able to set the minlen=1 for the UID_PersonHead. Just to be sure that error is coming from the Person.UID_Firmpartner.
Cancel
Up 0 Down

Reply

Verify Answer

Cancel