hello i have two tables 1.table name= Apple ...

[Selim_Tuncay]

hello i have two tables

1.table name= Apple

Column1=kind

column2=color

2.table name=sale

column1=saleKind

column2= quantity

column3- price

i want to take the most recent value of “Apple[kind]” and

set it to “sale[saleKind]” as a initial value.

how can i do it?

thank you

[Levent_KULACOGL]

@Selim_Tuncay if you have a datetime value in your Table1, you can set a MAXROW expression in a virtual column in Table2 and then call [MaxRowColumnName][kind] de-ref in [saleKind] column’s initial value

[Selim_Tuncay]

@Levent_KULACOGLU yes i have date value in Table1 do i create virtual column in Table1?

[Levent_KULACOGL]

@Selim_Tuncay VC shall be set in Table2. Then use de-ref expression in [saleKind] initial value

[Selim_Tuncay]

@Levent_KULACOGLU

thank you! it works

[Levent_KULACOGL]

@Selim_Tuncay you’re welcome Translate