Creating a simple app with two tables with a ...

[Steve_Langert]

Creating a simple app with two tables with a parent-child relationship.

Parent table creates a UniqueKey for each records.

Child table has many records related to the parent and holds the UniqueKey from the parent for each of the child records.

Appsheet automatically created the child form with “New” to add related records.

When I click on “New” it brings up a form with the UniqueKey from the parent already populated.

To my surprise, the user is able to change the UniqueKey value in the child record which breaks the relationship if it is changed.

I cannot figure out how to prevent the user from changing the value in the child record.

Help?

[RezaRaoofi]

Try marking that parent UniqueKey column as Hidden in child table’s column structure.

[Steve_Langert]

Tried that.

I checked hidden but then system rebuild unchecks it.

[RezaRaoofi]

Is that ParentKey part of a computed Key in Child table too? You could consider another independent key for Child table by putting UNIQUEID() in its Initial Value and make it hidden; this way it should also allow you to hide the ParentKey column too; once it is no longer part of the Child table’s key.

[Steve_Langert]

Different key in the child table.

Computed key that combines UniqueKey and Date.

I will test a completely independent key tomorrow.

[RezaRaoofi]

Yea, if the Parent Key column is part of the computed key, it gives you a warning in the Info page too, right after automatically unhiding it.

[Levent_KULACOGL]

@Steve_Langert

You cannot hide a key column. If you don’t want to show it in your form set the Show_if property to =FALSE

[RezaRaoofi]

Yup, Levent’s solution is better, if you don’t want to mess with existing computed key.

[Levent_KULACOGL]

@RezaRaoofi are we in the Community Watch bud?

[Steve_Langert]

@Levent_KULACOGLU It worked.

Thank you.

[Steve_Langert]

@RezaRaoofi It worked.

Thank you.