Re: Search & menu questions

2021-11-01 Thread Douglas von Roeder via 4D_Tech
4D has supported cross table queries since the introduction of the SQL engine in V11. Given a table of sales reps ("Managers") and a Territories table (not my table name convention) that have a many to many table ManagerToTerritory, the following code will find the territories for a given

Re: Search & menu questions

2021-10-30 Thread Jörg Knebel via 4D_Tech
> On 29 /10 /2021, at 10:24, Stephane Potvin via 4D_Tech <4d_tech@lists.4d.com> > 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

Re: Search & menu questions

2021-10-29 Thread Peter Bozek via 4D_Tech
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

Search & menu questions

2021-10-28 Thread Stephane Potvin via 4D_Tech
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