Can Filtered Records fetch any data from the Parent Record that Filtered them?

[FlyingRacoon]

Looking for a way to De Reference a Filter, is that even possible?  Or is there a way to get the previous record(-1) in the View Stack(Opened Views) to fetch its [field data].

Example:

Table(1) Record -> Gets a filtered list from Table(2).  I'd like to have the filtered records be able to pull information from the Table(1) Record that it's filtered by to inform some dynamic data in the Table(2) Record View.

Kitchen(1) -> Filter Rows from Meal List(2) that align with it the kitchen conditions.  But some Meals need to know what Kitchen making them so they can adjust their spec.  

Can't use a Ref, as Table(1) keys change daily, so can't do a normal Ref/Related etc.

Thank you for any ideas, probably no solution since theirs no way to anchor the Filtered Child records with the Parent Record to enable the Child to see the parent details.  But wanted to see if the community had some thoughts

[Steve]

---

@FlyingRacoon wrote:

Looking for a way to De Reference a Filter

---

Not possible directly.

---

is there a way to get the previous record(-1) in the stack to fetch its [field data]

---

Do you mean like LOOKUP(([_THISROW].[_RowNumber] - 1), "My Table", "_RowNumber", "field data")?

[FlyingRacoon]

I figured, na its not in the same table(_rowNumber-1).   

Parent table filters a Child Table for records matching the basic conditions.   Was just hoping I could make those Child records abit more dynamic and react to the Parent Record data. 

Vs having to make a bunch of static Child Records for every condition the parent record would then filter them for(ToD, Destination, servings, allergies, plating, etc).

Thank you for the reply