Two tables with the same column

[Gregorrrry]

I have two tables, both tables have a 'Date of next examination' column. 

I would like the 'Date of next examination' from one table to automatically update the other table.

Table to be pulled from is called 'Inspection Record'.

[Steve · Accepted solution]

Add a virtual column to the Assets table with an App formula expression similar to this:

MIN([Related inspections][Date of next examination])

Replace Related inspections with the name of the Related ... column in the Assets table that contains the list of related inspection rows for each asset.

[SkrOYC]

First, there are no "Two tables with the same column", because columns are unique in the context of it's table, although I know what you meant.
Second, the only way to "automatically update the other table" with the values from your current table is by having something in common between them, and we have no idea if that's the case

[Gregorrrry]

Sorry, I'll expand.

We have a form to create an asset which in turn creates a list. e.g. Vehicle 1.

Vehicle 1 is then inspected and an Inspection Record is created. Within the form the assets are chose from a reference dropdown. 

Within the inspection record the 'Date of next examination' is automatically created using the formula '[Date of this examination]+180'.  When someone then looks at the asset table, we would like the 'Date of next examination' within the form to be updated automatically when the inspection record is completed. 

Hope that makes sense.

[Steve · Accepted solution]

Add a virtual column to the Assets table with an App formula expression similar to this:

MIN([Related inspections][Date of next examination])

Replace Related inspections with the name of the Related ... column in the Assets table that contains the list of related inspection rows for each asset.

[SkrOYC · Accepted solution]

---

@Gregorrrry wrote:

When someone then looks at the asset table, we would like the 'Date of next examination' within the form to be updated automatically when the inspection record is completed. 

---

Use actions.
You need an action that fires in form save and the action should be of type "Execute an action on a set of rows".
The rows should be referenced by using an expression like this:

LIST(
  [Chained].[Dereference].[To].[Id]
)

You create another action on the table that has the data you want to update with the expression you want, and you select this one in the previous one