Solved: Initiale value in the same form - Page 2

Hinse_Wouters · 02-03-2022 04:57 AM

Hello guys,

I have table 1 with a column name and a column value.

In the seconde table i have a name (ref colum) and an empty space.

Nog when i start with a form in the seconde table and i give the ref name a value, the value that is connected to the same name in column 1 needs to be given.

BUT: I also needs te be replaceble? or leaved empty when there is nog value.

I started with an ANY(SELECT(.... but when i put it in the INITIAL VALUE -> It doesn't return a value.. Is this beacuse i'm already in the form and an INITIAL VALUE needs to be predicted before i open the form?

is INITIAL VALUE not the richt column to fill in?
When i choose -> FORMULA it isn't editable anymore..

Can somebody help me with this?

TeeSee1

@Hinse_Wouters

I was wrong here

Again as you have already guessed, the initial value is determined when you open a form to add a row and in this case, a value cannot be proposed based on the value of the Nummerplaten which is not determined initially.

You can set an expression in the initial value and extract a value based on the selection of another field. You can choose to accept the proposed value or change it including deleting it.

The expression I used in the below snippet is

[numberplate].[driver]

where numberplate is a ref col to the ref col in numberplates table where there is a col - driver.

Will this help?

View solution in original post