value lists - based on 2 tables

[sotiris_2]

How to create a list value based on two tables ?

Let’s consider the case with 2 tables. The table Session :

Pk_ID_Session

DateSession

HourStartSession

HourEnd

Fk_ID_ScheduleClass

…

and the 2 table:

pk_ID_ScheduleClass

DateClass

HourStartClass

HourEndClass

…

Now, I would like to create a value list where:

Session::DateClass = ScheduleClass::DateSession

AND

Session::HourStartClass = ScheduleClass::HourStartSession

Can you help how to do this ?

Thank you