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

(Selim Tuncay) #1

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 KULAÇOĞLU) #2

@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) #3

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

(Levent KULAÇOĞLU) #4

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

(Selim Tuncay) #5

@Levent_KULACOGLU

thank you! it works

(Levent KULAÇOĞLU) #6

@Selim_Tuncay you’re welcome Translate