by Frank Wiles on Aug 4, 2006 One of the great things about modern databases is you can let your database automate some of what used to only happen in application logic.
The example I love to show people is automatically updating a "last modified time" timestamp column in a table.
Create another Query that filters all tasks that have already reached the 7th hours (SELECT Task ID FROM Tasks Where Seveth Hourd Reached ="Yes" GROUP by Task ID) - Lets call this query Tasks7H Make sure the field Seveth Hour Reached shows on your Form but disabled or locked or disabled and locked.
File Maker does not use SQL set semantics on queries.
File Maker may execute one query for each related table on a layout.
(Each record currently contains a single field with a running total of hours recorded) There are a number of ways that you can do this if you are using a Form to insert new records into your table.
It would also help if you have some knowledge of VBA If you are are using MS Access 2013, you could also use Data Macros (MS Access equivalence of SQL Server triggers).
To identify whether a table in the relationships graph is a File Maker table or from an ODBC data source, move the pointer over the arrow in the table header. You can remove fields if you do not want File Maker Pro to display them within your solution.