ly cumbersome (even error-prone) experience. I decided to pair each Date field with a second Text field that I could write my own parsing code for. For example, if you have a Date field named DOB, and then you add a second Text field named DOB_Entry, putting the code near the end of this post into the latter's Trigger after update (see Table > Edit Fields..., and then look in the More options area and...

This should take care of that problem. It also checks for 0 cents so the " and" won't be displayed in that case. let empty := "";let x := [empty, "One ", "Two ", "Three ", "Four ", "Five ", "Six ", "Seven ", "Eight ", "Nine ", "Ten ", "Eleven ", "Twelve ", "Thirteen ", "Fourteen ", "Fifteen ", "Sixteen ", "Seventeen ", "Eighteen ", "Nineteen "];let y := [empty, empty, "Twenty ", "Thirty ", "Forty " User...

concat() or join(). Also, if you use a for-loop, the only time it would evaluate to true is if last item in the array matched the chk value, but that is only if you assign the result to a variable and return the variable. This works if you use join() on the array... function aContains(txt : text,chk : text) dolet ar := split(txt, ",");let myChk := false;let lpCnt := 0;while lpCnt < cnt(ar) and not and...

Thanks for responding. I agree that it takes time and practice ( and patience) to learn a new computer language, but I am finding documentation to be quite limited compared to documentation for other database products I have used in the past. Not really complaining, just feeling I should not need to rely on other users for simple coding. So, as I said, I really appreciate your input. To answer your and...

Thosbryan - the data model you want to build will contain three tables - two parents and a child. The Parent (or Master) tables are Clinics and Caretakers. The third table is a child table called Appointments which is a child to Caretakers. The reason for the Parent/Child relationship is that without caretakers there would be no appointments. Also, this relationship will make it very easy for you and...