> On 29 /10 /2021, at 10:24, Stephane Potvin via 4D_Tech <[email protected]> > wrote: > > Main table is client information, linked table for services provided.
Beside the super duper modern cool way to get a result what about the solid old way: $DateServiced:=Add to date(current date(*);-1;0;0) // or value entered by a user QUERY ([Services]LastServicedDate<=$DateServiced) RELATE ONE SELECTION([Services];[Clients]) Your description about the menus is a knew one to me - sorry. HTH Cheers Jörg ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
