Child records not getting reference id when added

AppSheet AppSheet Q&A
1

I have a Parent table (Clients) with 2 child tables (Visits) and (Members).
The original data was imported.
Parent has field unique Client_ID that was set as key.
Visits has the fields Visits_ID that was set as key and a ref Client_ID to the client.
Same structure for Members.

After import everything looks great, with Members and Visits listed with the appropriate Client.

UNIQUEID() is the initial value for all key fields.

Adding child records inline (hope that is the correct term). The Members,Visits records are created but they don’t have a Client_ID ref value - they are orphans.

What am I missing?

2

From where are you triggering those child records?

1 Like
3

Likely ‘Is a Part of?’ is off, in your Visits/Members table - in your ref column.

Likely you are not creating rows for the Visits/Members table when you are creating a row in Clients table.

4

This is just the system add action. Part of is set,

5

Not adding new Clients here - just adding child records.

6

From what view do you add those child records? Are you triggering it from the parent record’s detail/inline view? I mean with the “New” action?

1 Like
7

I’m a newbe, and this is a test system and my first. So, I might be missing something obvious.
I am using the ‘primary’ view on the Client and the system ref views.

I edit or view the Client - child records are display properly in line – I add child records there.

Yes, the NEW action.

1 Like
8

Would you please take a prinscreen from that view where you trigger that child record.

1 Like
9

2X_3_3e4f16badb45c653ad6ec3198cd38ecb0a34d675.png
2X_3_3e4f16badb45c653ad6ec3198cd38ecb0a34d675.png325×619 29.1 KB

2X_c_cdfad10f8883a9a887bdaf0f80111792921666db.png
2X_c_cdfad10f8883a9a887bdaf0f80111792921666db.png312×647 17.6 KB

I moved the child grids to the top of the Client data - most of the time the user would just view the child info.

1 Like
10

Aleksi, to be clear, I am clicking NEW below the child grids.

11

So… when you add a new visit, you click that “New” button under $0.01?

12

Correct

13

Any chance that the Ref field is set as not editable? That would explaing this behavior.

6 Likes
14

Yes, not editable. Changed and first test worked correctly on both tables.

Thanks, Aleksi.

1 Like
15

Excellent!