date - year - select - vista
Hi everyone, I have a question for you.. if it is possible..
I have a table "PACCHETTI" with a linked-field to another table: "scuderia" and a date field. Then I've a vista field with this code:
let xscud := SCUDERIA;
select VISITE where PROFILASSI and PAZIENTI.'LUOGO DI DETENZIONE' = xscud
This select statement works correctly and shows a list of specific "VISITE" linked with a specific "scuderia" and with a date.
I would like to have a date field in order to select in the vista field only the "VISITE" happened in that "Scuderia" and in a specific year, ex. 2020.
Is that possible to set the date field in this table with only the possibility to choose a year ?
2 replies
-
You can add this line to your VISITE formula to get the data from your current record:
let curRec := this;
Then add this to your select statement:
select VISITE where PROFILASSI and PAZIENTI.'LUOGO DI DETENZIONE' = xscud and [date field from VISITE] = curRec.[date field from current table]
-
I'LL try! Many thanks.
Content aside
- 3 yrs agoLast active
- 2Replies
- 319Views