Ref Id (Key from Parent Table) is not reflected in Child Table

Hi,
Parent Table Data

PA Id # -> Key

Child table Data

The PA Id # is not shown in the Child Table.

Before, it’s working fine. I changed the columns structure & regenerated & facing this issue
I also, changed the Security Filter to FALSE to support data as per guidance.

Any idea why?

Thank you.

How would the child row get a value for PA Id #?

Let me put it clearly.
I meant that, PA Id # (key) value should be reflected in the Child Table.But,it’s not.
It’s the Ref value from the Parent table.

Why is the yellow Exclamation shown near the PA Id # key?
image

Label -> Date
Key -> PA Id # , a uniqueid() value.

I referred the posts, Since a while I get an exclamation mark next ... & No Errors but a caution sign appears in my app.

  1. I checked for broken references, but, all seems ok to me.I have regenerated the app several times.
  2. I have even deleted the Table & Added, Configured again. I am getting the same error.
  3. I have copied & just pasted the table values again, it’s still not doing any good!

Am clueless. Pls support.

I tried copying the Order Capture app & tried to save new Order Detail.

Order Id # -> Parent table Key
image

Order Detail Id # -> Child Table Key.
image

The former is also shown in the Child Table.

It’s working fine with that app. I don’t know where am I going wrong.

1 Like
  1. What is the name of your parent table?

  2. What is the name of the key column of the parent table?

  3. What is the name of your child table?

  4. What is the name of the key column of the child table?

What is the name of your parent table? -> PA Data
What is the name of the key column of the parent table? -> PA Id #
What is the name of your child table? -> Daily Associate PA
What is the name of the key column of the child table? -> Associate PA Id #

1 Like

Whoops! I overlooked this:

That’s your problem, or at least a part of it. A security filter of FALSE filters out all rows of the table.

So, any workaround for this?
If I don’t set Security Filter, I am getting series of errors with my app,

  1. Even though, the table is available, it’s showing inaccessible or empty
  2. Even after Regenerating the column structure, it’s showing the same error message.The updated Table structure is not reflected in the app.

Appsheet.Errors.Daily Associte PA Table

Appsheet.Errors.Daily Associte PA Table1366×625 151 KB

Error
Error463×698 14.9 KB

The App is Regenerating the Structure but,instead of the Table structure, the whole page is getting refreshed even after repeated tries.Hence, the changes in the Table is not getting reflected in the app.

May I know why the following error occurs?

Thank you

1 Like

It appears you did more than just take the security filter out. Please engage support@appsheet.com for further help. I don’t have the access necessary to do so.

1 Like

Thank you for your time & effort

1 Like

I just noticed, Security filter of FALSE is set to the Child Table & not the Parent Table.
Will that affect too?

1 Like

A security filter of FALSE will make all of the rows of that table unavailable to the app. For all practical purposes, the app will see the table as empty.

1 Like

Great. Thanks for the update

1 Like