• Registered: 2017-12-10
  • Posts: 81

Topic: Calculated field

I use the following Calculated Field in the table "Deelnemer": ifnull(d_naam,'')||',  '||ifnull(d_roepnaam,'')||' '||ifnull(d_tussenvoegsel,'')||'  -   '||ifnull(strftime('%d-%m-%Y', d_geboortedatum),''). So I can perform an incremental search on the 3 fields.

Now I want to know if it is possible to include one or more fields from a diifferent  table in the Calculated Field.

kees.krause's Website

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: Calculated field

Hi Kees,
Yes, this can be done - please have a look at the example and let me know if anything's not clear.
Regards,
Derek.

Post's attachments

Attachment icon kees.zip 336.69 kb, 304 downloads since 2020-03-10 

  • Registered: 2017-12-10
  • Posts: 81

Re: Calculated field

Derek, thanks again. It works perfectly

kees.krause's Website