On Fri, Oct 29, 2021 at 1:25 AM Stephane Potvin via 4D_Tech < 4d_tech@lists.4d.com> wrote:
> Hello all. > > Hoping someone can help me. > > I have two questions. > > 1. My partner provides piano tuning services and I built a DB for us to > keep track of her clients, their pianos, and the tuning/services she > provided on each piano. > Main table is client information, linked table for services provided. > > So that I can contact clients who have not had their piano tuned in a year > of more, I want to search for only those clients whose last service was a > year or more ago. > > Is there a not too complicated method that will accomplish that? > Stephane, I would do the task in several steps: 1. Find out all clients that are eligible for tuning service - maybe this are all clients, maybe you may want to restrict them to active clients (say, ordered some service in last 5 years.) 2. Find all treatments after specified date, and project selection of treatments into Client table - this will create a set of clients that had tuning service after specific date. 3. make a difference between two sets. The actual code becomes exceptional simple with ORDA, where it would look like (coode not tested) var $allClients; $tunedClients; $notTunedClients : cs.ClientSelection $allClients := ds.Client.all() $tunedClients := ds.Tuning.query("TuningDate >= :1";$tunedAfterDate).TuningToClientRelation $notTunedClients := $allClients.minus($tunedClients) Client and Tuning are names of tables, TuningToClientRelation is the name of the relation from Tuning to Client table. The same can be achieved with old syntax, using sets. > 2. Having migrated my db to v. 18, the File, Edit, and User menus display > numbers instead of text menu items. (see attached) > > How can I get the menus to display properly in MacOSX 10.14.6? > Menus should work properly, I converted several DBs. You have not included screenshot, but just screenshot probably is not sufficient to find out where is the problem. HTH, -- Peter Bozek ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************