Horizontal Scaling in a slice / Child table

[Louwrens]

Good day Appsheet Community.

I am looking for a way to filter data on a slice using a column value from the Parent table.

Parent table Name = Fleet_Information
The key of this table = Registration
Filter Column - Fleet Status = Active

Child table should only show data where the fleet status is = Active
Child Table name = Fleet Service and Compliance

Hope someone can help.
I know this is probably something with a easy solution but, I can’t seem to figure it out.

[LeventK]

@Louwrens
Do you want to do this in the inline view of the child records in Parent record’s Detail View?

[Louwrens]

Nope,

I want to create a slice only showing the active fleet.

[LeventK]

Simply your REF_ROWS() expression should point out to that slice rather than the table itself, if that’s what you are asking.

[Louwrens]

I need to show all the columns in the Fleet Service and Compliance (Child Table) if the Fleet Status = Active in Fleet_Information (Parent Table).

As I said its probably something basic but I seem to not be able to figure it out.

[Aleksi · Accepted solution]

You should be able to do that with the deref formula like [RefColumnName].[Fleet Status]=“Active”