I have three tables Clients, Services & Volunteers I have a form view on Services where volunteers select themselves as service providers and a specific client, assigned to them in the Volunteers table. The problem is that when selecting a Client, al...

currently this appears to be not selectable. It does wipe out existing data in the field. I thought OK in the else condition just return self, or the same column that it is calculating, but this cannot be selected, yikes! In order to archive lookup ...

Such a example would high light the issues of auto population, and retained values on lookup and roll up after dependent values change. As well as a few other issues. An example, I believe would be the easiest way to explain how to do this most basi...

The calendar picker is rendered fairly useless when you try to add a non local date such as a birth date. Yes, you can enter the date as text. But a date picker is less error prone. I suggest something like and arrow above and below the year in the...

How to we limit the pick list for new records, while retaining old data in existing records. When we have a multiple select field for staff, for instance, and some staff leave so that we do not want to have anybody select them. But, existing histori...